Use #CreateODBCDate()#
You can use this in combo with #isDate()#
#CreateODBCDateTime()# is also available.
Shan
Shannon Hicks
Senior Developer
Allaire Certified ColdFusion Developer
Brainbench Certified Master ColdFusion Developer
[EMAIL PROTECTED]
duoDesign, The eBusiness Accelerator
1007 Church St. Suite 510
Evanston, IL 60201
847.491.3211
847.491.3100 fax
http://www.duodesign.com/
http://www.chicagoangels.org/
-----Original Message-----
From: Nat Papovich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 4:22 PM
To: Fusebox
Subject: RE: Date Type for SQL Server
{Use curly braces}
> -----Original Message-----
> From: David Huyck [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 12:02 PM
> To: Fusebox
> Subject: Re: Date Type for SQL Server
>
>
> <cf_sheepishly>
> I'm working on an ASP project...
> </cf_sheepishly>
>
> David Huyck
> [EMAIL PROTECTED]
>
>
>
> | 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...
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
