[thelist] adjusting for timezones in Oracle

[Anthony Baratta]

How about:

SELECT SESSIONTIMEZONE FROM DUAL;

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