Convert UTC time to local time

[system]

Hi,

In one of our jobs, we have a date which is being received in UTC time format.

The same needs to be converted to the local time zone.

Can someone please give tips on how to achieve this?

Thanks,
Bhupendra

---

ds41user (BOB member since 2007-09-03)

[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)