Posted by Erland Sommarskog on 01/19/06 00:08

Alexander Kuznetsov (AK_TIREDOFSPAM@hotmail.COM) writes:
> In such cases it helps to be specific. For instance, instead of
> '2005-01-03'
> use convert(datetime,'2005-01-03',120)

No, that was not was I was thinking of. I meant:

sql = "UPDATE rfa SET dateClosed = ? WHERE rfaId = ?"

Which was in a previous article of mine in the thread.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]