YSpa
Last Activity: Mar 19 '08, 12:22 PM
Joined: Jan 30 '08
Location: Netherlands
-
Not that I know of. But if I had, shouldn't YYYY-MM-DD still function?... -
SQL-Server 2005 suddenly doesn't accept date format YYYYMMDD
Hi,
I'm using SQL-Server Express 2005 on Windows XP Prof. and after working properly for some time my asp.net application suddenly gave the error that my DateFormat wasn't accepted while using YYYY-MM-DD. Never mind my asp.net application, even in the Management Studio, SQL Server doesn't seem to accept the following query:
It returns the following error:Code:SELECT * FROM (table) WHERE (table).(date) = '2008-1-30'
...
No activity results to display
Leave a comment: