SQL server would also accept '2001-3-22'
Tom
At 07:18 PM 3/22/01, you wrote:
>Use CreateODBCDate()
>
>---
>Jeffrey B. Marsh
>Professionals built the Titanic.
>Amateurs built the Ark.
>
>-----Original Message-----
>From: David Huyck [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 22, 2001 9:06 AM
>To: Fusebox
>Subject: OT: Date Type for SQL Server
>
>Okay, quick question: In Access you can pass date/time in your SQL query
>like this:
>#3/22/2001#
>
>How do I do the same thing in SQL server? It seems to dislike the #pound
>signs#... I know I've seen this question answered before, I just don't
>remember what the answer was...
>
>Thanks,
>David Huyck
>[EMAIL PROTECTED]
>
>****************************************************************************
>This message is intended for the sole use of the individual and entity to
>which it is addressed, and may contain information that is privileged,
>confidential and exempt from disclosure under applicable law. If you are
>not the intended addressee, nor authorized to receive for the intended
>addressee, you are hereby notified that you may not use, copy, disclose or
>distribute to anyone the message or any information contained in the
>message. If you have received this message in error, please immediately
>advise the sender by reply email and delete the message. Thank you very
>much.
>****************************************************************************
>****************************************************************************
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
