Oracle accepts the following format "10 JAN 2002" which I like because it removes any potential ambiguity regarding days & months ... which can occur dependant on the locale of Oracle server
wouldn't an ODBC/JDBC timestamp string, {ts 'YYYY-MM-DD HH:MM:SS'}, be the simplest solution - assuming your db drivers support it. I've only had one problem with this and that was a few years ago with an oracle odbc driver for linux, i think it was the merant one shipped with cf4.5.
Mark
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
