I am not sure if Oracle directly supports am/pm, but try using the built in database 'timestamp' creation command. In MS SQL it is getdate(). The equivalent should store it in the database's native format.
Ryan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Smith, Jim Sent: Tuesday, January 22, 2002 8:07 AM To: Cold Fusion Listserv (E-mail) Subject: [KCFusion] Storing Date/Time I'm having trouble storing the date/time in an oracle table. I want to use am and pm on the time. CreateODBCDateTime complains about the am and pm. I can get it stored if I leave that off. What am I doing wrong? ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[email protected] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[email protected] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
