Hi Friends,

You would know that SQL Server 2008 DateTime and DateTime2 data type amongst many new data types. Here is an interesting observation. Comments are welcome:

When you run the following code with the default date format setting, you get the right output:


But when you change the format to dmy; you get a different output :)


Comments are welcome.