Originally posted by BeyondCloister
Now that the clocks have just gone forward an hour, all of my times are wrong. How do I get the correct time using the TO_CHAR function for a time with the an offset from GMT?
The new Oracle datatype TIMESTAMP WITH [LOCAL] TIME ZONE caters for this, I guess (haven't tried it). With normal DATEs you will just have to make the adjustment to the DATE value BEFORE you TO_CHAR it. e.g.:
SQL> SELECT TO_CHAR(SYSDATE,'HH24:MI') bst_time,
2 TO_CHAR(SYSDATE-1/24,'HH24:MI') gmt_time
3 FROM DUAL;