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

• Next in forum: Re: New job opportunities
• Prev in forum: New job opportunities
• Thread view: Re: Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL

[Reply to this message]