Convert UTC time to local time

[system]

this should help you -

120×120 10.4 KB

Database stores date-time in a UTC format. I want them to be displayed in a GMT +1:00 format. The oracle database settings are set to +2.00 (select dbtimezone from dual) Simply adding hours doesn’t help cause: daylight saving settings are different in both formats NEW_TIME function in Oracle should help: NEW_TIME( TABLE.date , 'TimeZone1', ' TimeZone2') But what values should I use voor TimeZone1 and TimeZone2 to obtain the wanted results? Tiny (BOB member since 2004-11-…

as always, search before you post

---

BODSDW (BOB member since 2011-01-19)