SQLSmasher (2/10/2011)
It is quite good question for initial telephonic interview. And you can give simple answer by1. CONVERT is SQL speicific but CAST is ANSI standarised
2. CONVERT deal nicely with datetime using format, which is missing from CAST
1. You mean specific to the TSQL dialect.
2. In that case, a better question would be: "How would you format a datetime value to the ISO compliant format?"
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP