Page 1 of 1

mssql convert sintax

Posted: Fri Mar 13, 2009 10:01 am
by elpepefontana
I got these convert sintax:
the date comes from a previous query(another mssql db).

convert(datetime,'25-2-2009 0:00am',0)

where is the error, can it be the date's format? is there a simple way to correct it?

the error is:

Warning: mssql_query() [function.mssql-query]: message: Line 5: Incorrect syntax near '25'. (severity 15)