Posted by Alexander Kuznetsov on 01/18/06 18:54

In such cases it helps to be specific. For instance, instead of
'2005-01-03'
use convert(datetime,'2005-01-03',120)

• Next in forum: Re: how to get tables involved in constraint
• Prev in forum: Problem ith DTS and delimited file with empty last column
• 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]