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/functions31.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/expressions7.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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists