Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining the time zone for an Oracle DB/Server
Not sure if this will help you, but you might have a look at the new_time
function. Below is a snippet from the doc.
NEW_TIME
Syntax
NEW_TIME(d, z1, z2)
Purpose
Returns the date and time in time zone z2 when date and time in time zone
z1 are d. The arguments z1 and z2 can be any of these text strings:
AST
ADT
....
Received on Tue Jul 20 1999 - 22:27:46 CDT