Here is what I normally use, granted the 'masks' are different but I think
you get the jist.
to_date('#DateFormat(Now(), "mm/dd/yyyy")# #TimeFormat(Now(), "h:mm:ss
tt")#', 'MM/DD/RRRR HH:MI:SS AM')
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-----Original Message-----
From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 2: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
(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
