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:337704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
