DATETIME 1

[747576]

Hi there,

I am getting the following error when casting the date '24/08/2007 10:40:00' in the sql below:

select cast('07/04/2009 14:57:00' as DATETIME)

ok

select cast('24/08/2007 10:40:00' as DATETIME)

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Is this to do with the sql server data format set. Can this be set in the server without using:

SET DATEFORMAT dmy

Thank you

 

[gmmastros]

It's the language of the login that is causing your problem. Read this:

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Very funny

http://forums.asp.net/p/1434550/3228710.aspx#3228710