Timezone information - conversion of date/times

From: Tony Cook <TCook_at_vtrlmel1.trl.oz.au>
Date: 14 Oct 1994 05:01:02 GMT
Message-ID: <37l3ae$c03_at_newsserver.trl.OZ.AU>

Hello All,

Does Oracle provide any facilities to handle conversion of times from one timezone to another?

I have had a browse through the manuals but can not find anything related.

How does everyone out there handle software that needs to know about the time in different timezones and the conversion required between zones? - Store everything in GMT/UTC and convert to local time when needed?

I would appreciate hearing your experiences.

I am writing PL/SQL on a unix host with pc clients in a few different time zones.

Tony Received on Fri Oct 14 1994 - 06:01:02 CET

Original text of this message