The key to those URLs is "9i". I don't follow the standards for SQL so I don't know how long current_timestamp and "at time zone" have been around, but they aren't in 8i. My fault for not specifying the database version since I was only looking through the documentation for what we've got here.
The "Standards, pshaw ..." was simply humor. And yes, it could be for the lack of standards compliance because I can't use those standards. :) Dan -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:43 AM To: CF-Talk Subject: Re: Timezones and CF Dan Haley wrote: > Near as I can tell the Oracle equivalent of this is new_time(). The Oracle equivalent of "current_timestamp" is "current_timestamp". http://www.google.com/search?q=oracle+current_timestamp http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/fu nctions31.htm > I tried finding something on "AT TIME ZONE" but wasn't able to. The Oracle equivalent of "AT TIME ZONE" is "AT TIME ZONE". http://www.google.com/search?q=oracle+%22AT+TIME+ZONE%22 http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/ex pressions7.htm > Standards, pshaw ... I'm afraid I don't understand this remark. It can't be the the lack of standards compliance in this case. Could you elaborate? Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
