Try using "sysdate" instead of trying to get the correctly formatted date (as
demonstrated below). Then you can use CF functions to get the correct format
when you pull it out.
Thanks,
Kevin
-----Original Message-----
From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 12:44 PM
To: CF-Talk
Subject: Oracle insert DateTime HELP
I'm trying to insert both the date and time into an oracle table. I can't
seem to get the syntax right. Any suggestions?
<CFQUERY name="InsertDate" datasource="#application.dsn2#"
dbtype="#application.DBTYPE#">
INSERT INTO
temptable
(StartDate) VALUES
(sysdate)
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists