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
(to_date(#DateFormat(SDate,'DD-MMM-YYYY HH MM SS')#,'DD-MON-YYYY
HH24:MI:SS'))
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
