Daniel, Try this:
to_date(<field>, "mm/dd/yyyy HH24:MI:SS") to do the insert. This will cause Oracle to interpret the date correctly. -Drew Nathanson > I have a date/time that I made using SYSDATE and inserted into an > oracle table. It looks like "2010-09-30 13:34:17.0". I have queried > for that date to insert into another table, but when I go to insert it, > I receive a "missing comma" error. I assume that it has to do with > the date because when I remove the date or put in SYSDATE, it works > fine. > > What do I have to do to this date to make it reinsert-able? I'd > prefer to not parse it and then remake it with createDateTime because > it seems it a fine date as-is. > > > thanks for the help. > > > daniel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm