Datatype format conversion error?

[Zac5]

The following works in my query analyzer without any problems:

select convert(datetime,'28-5-2006')

however gives an error on query analyzer installed on another machine.

I have checked regional settings for both PCs and they are the same English(United Kingdom). Any suggestions please?

 

[SQLDenis]

try executing
SET DATEFORMAT MDY first


However you should always use ISO dates (YYYYMMDD) because those should always work

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

Denis's advice is exactly what you need.

For a little more backgroun, I suggest you take a look at this thread: thread183-1240616.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom