Or, if you are using ODBC as opposed to native drivers, you could use the
odbc escape sequences:
<CFQUERY datasource="dsnname">
INSERT INTO a_table (aDate, aText) Values ({fn CURRENT_TIMESTAMP()},
'TEST')
</CFQUERY>
{fn is a "curly-brace fn " not "parenthesis fn".
check them out at:
http://msdn.microsoft.com/library/psdk/dasdk/odch34df.htm
Appendix C and Appendix E
<Jaime Garza/>
-----Original Message-----
From: Marc Garrett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 10:44 AM
To: CF-Talk
Subject: Re: Date Timestamp??
Wouldn't it be better to let the database handle it instead of CF? Which
database are you using Rich?
Regards,
Marc Garrett
----- Original Message -----
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 11:32 AM
Subject: RE: Date Timestamp??
> If you are wanting to put the current date and time try this:
>
> #CreateODBCDateTime(Now())#
>
> That will insert the current date and time as a timestamp
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
