On Wed, Oct 25, 2006 at 01:09:55PM -0400, Joel wrote:

Thanks everybody for hints. Now second question confused me ;)

I have an unix date-time value ("seconds from epoch"), but it is in GMT
timezone. I have to convert it to my zone ('Europe/Moscow', or 'MSK', or
'MSD' where daylight saving in use). I saw technich how to convert unix
date-time to Oracle date, and also i saw new_time function. But new_time
accepts only several timezone names, so how can i convert my date from
GMT to my zone?


--
Antuan Avdioukhine (DEKA-RIPE).
Convey Plus Telecommunications
St.Petersburg, Russia.

Oracle LazyDBA home page