[thelist] adjusting for timezones in Oracle

Anthony Baratta anthony at baratta.com
Tue Oct 13 12:15:15 CDT 2009

How about:


Then use that info to munge your date info?

Jeremy Weiss wrote:
> I've been building some reports that query an Oracle db. Today I
> learned that the labor entries are stored in GMT so I need to modify
> some of my reports to adjust the time to the appropriate time zone. So
> far, all I've found is
> TO_CHAR(NEW_TIME( table.column ,'GMT','CST'), 'MM-DD-YY HH24:MI:SS')
> which appears to work. But I'm concerned that with this method, the
> reports will have to be edited twice a year to account for daylight
> savings time (CST to CDT and back).
> Anyone know of a way to have the query just pull in timezone of the
> server? Or is there some other obvious method that I'm missing?
> thanks,
> -jeremy

More information about the thelist mailing list