Re: timezone conversions?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 10 Mar 2009 17:10:17 +0100
Message-ID: <49b690e8$0$2675$426a34cc_at_news.free.fr>


"steph" <stephan0h_at_yahoo.de> a écrit dans le message de news: f86e6848-4c33-47ed-bb01-4873b8e40f6f_at_41g2000yqf.googlegroups.com...
| hello group,
|
| What's the easiest/preferred way to programmatically convert a
| timestamp value from one timezone to another? (i.e. subtract/add the
| necessary number of hours). I checked the documentation but
| unfortunately missed any one function to switch timezones.
|
| thanks,
| stephan

Maybe NEW_TIME function.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions092.htm#i1004085

Regards
Michel Received on Tue Mar 10 2009 - 11:10:17 CDT

Original text of this message