Avatar of Abiel de Groot
Abiel de Groot
Flag for Spain

asked on 

Date format in SQL 2005

Is there a way to specify the default date format on a specific database.

I was using sql2000 and am now using sql2005. When my script tries to insert this date format:

blankStartDate = "1900/01/01"
blankEndDate = "2079/06/06"

I egt this error.

Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
/grupo_gsi_adip2/VD_Editor/WebPages/WebPageDoFiles/DoSaveWebPage.asp, line 42

The server (Spanish) is rendering this format too when using the date() object. Such as

"LastUpDate = '" & now()  & "'," &_ ... etc

I shouyld be able to specify somewhere to use this european date format...

Microsoft SQL Server

Avatar of undefined
Last Comment
Abiel de Groot

8/22/2022 - Mon