Oracle: epoch date to date with CEST and CET
I got a date like this '1302104376' stored with the italian timezone UTC+1. I need to convert it into the format DD:MM:YYYY HH:SS, but with timezione UTC + 0 (GMT). Does exists a function that does the work, paying attention to the daylight period ?
Thanks for your help Simone
This should get you close:
SQL> SELECT TO_CHAR(TO_DATE('19700101','YYYYMMDD') + (1302104376/(60*60*24)),'DD:MM:YYYY HH24:MI:SS') the_date FROM dual; THE_DATE ------------------- 06:04:2011 15:39:36 SQL>
You'll need to adjust your output accordingly for differences in timezones, DST, etc.
This site is highly instructive regarding epoch dates.