select * from shifthistory where vfrom='2009-07-23 00:00:00'. i get an error.

select * from shifthistory where vfrom='23-07-2009 00:00:00' It works.

select * from shifthistory  

select * from shifthistory where vfrom='2009-07-23 00:00:00'. i get an error.

select * from shifthistory where vfrom='23-07-2009 00:00:00' It works.

select * from shifthistory  

select * from shifthistory where vfrom = convert(datetime, '2009-07-23 00:00:00', 120)

set dateformat mdy
select cast('2009-07-23 00:00:00' as datetime) -- works
go
set dateformat dmy
select cast('2009-07-23 00:00:00' as datetime) -- fails
go
set dateformat dmy
select cast('23-07-2009 00:00:00' as datetime) -- works
go