how sql server decides datetime format to use implicit conversions?

[Shwet Jain]

declare @str_datetime varchar(50)
set @str_datetime='30-04-2012 19:01:45' -- 30th April 2012
declare @dt_datetime datetime
select @dt_datetime=@str_datetime

Added mandatory [CODE] tags for youThis is giving following error
Msg 242, Level 16, State 3, Line 4
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

My question is how sql server decides which format to use for implicit datetime conversion?

[ck9663]

Here, read this

Good Luck!!!


~~ CK