mssql convert sintax
Posted: Fri Mar 13, 2009 10:01 am
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)
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)