Convert to Global Time Zone using the Time Zone conversion

rameshkm · Post by **rameshkm** » Tue Jun 01, 2010 3:16 am

Hi,
I have a Situation as "Convert to Global Time Zone using the Time Zone conversion " for given timestamp field , Please help in this , thanks in ADVANCE

ArndW · Post by **ArndW** » Tue Jun 01, 2010 3:20 am

A timestamp does not contain time zone information, so you need additional data in some form to (a) find out what time zone a given timestamp value is in, and (b) define 'global time' for your application and add/subtract the requisite number of hours from your timestamp.

What database (some support timezones) is your data coming from?

ray.wurlod · Post by **ray.wurlod** » Tue Jun 01, 2010 4:57 am

In addition to what Arnd advised, your method may need to handle changes in time within a time zone (usually called "summer time" or "daylight saving time"). Sometimes the change dates are regulated, some places it's more erratic. And some countries involve more than one time zone.

udayk_2007 · Post by **udayk_2007** » Tue Jun 01, 2010 6:44 am

If you are using oracle database,then you can do time conversion in different time zones using new_time function

new_time( date, zone1, zone2 )