Near as I can tell the Oracle equivalent of this is new_time(). I tried finding something on "AT TIME ZONE" but wasn't able to. Standards, pshaw ...
The URL below (probably wrapped 'cuz I use Outlook, but I don't care because it's a corporate kind of thing) has some interesting date functions for Oracle, but doesn't say what version. Ones I didn't know about ... last_day() for the last day of the month, and the use of round to give you the first day of the year/month/etc. http://cis.csuohio.edu/~matos/notes/cis-612/Oracle_Notes/html_notes/SQL-Func tions.html Dan -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:29 PM To: CF-Talk Subject: Re: Timezones and CF Greg Luce wrote: > I'm just familiar with Oracle, SQLServer, and Access. Oracle has > "sysdate", while I believe SQL and Access use getdate(). You are right. If we are going to do it according to the standards, better do everything according to the standards :) SELECT current_timestamp AT TIME ZONE '#your_time_zone#' AS myTime 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