Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining the time zone for an Oracle DB/Server

Re: Obtaining the time zone for an Oracle DB/Server

From: Juan Carlos <jc_va_at_hotmail.com>
Date: Tue, 20 Jul 1999 20:27:46 -0700
Message-ID: <7n3463$84c$1@bgtnsc02.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US