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:

1_SQL_Server_DateTime_DateTime2_behavior

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

2_SQL_Server_DateTime_DateTime2_behavior

Comments are welcome.