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: Dates

Re: Dates

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Mon, 17 Aug 1998 18:42:09 +0200
Message-ID: <6r9mfj$354$1@newton.a2000.nl>


You can use new_time. Taken from the online help:

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   Atlantic Standard or Daylight Time
BST, BDT   Bering Standard or Daylight Time
CST, CDT   Central Standard or Daylight Time
EST, EDT   Eastern Standard or Daylight Time
GMT Greenwich Mean Time
HST, HDT Alaska-Hawaii Standard Time or Daylight Time. MST, MDT Mountain Standard or Daylight Time NST Newfoundland Standard Time
PST, PDT Pacific Standard or Daylight Time YST, YDT Yukon Standard or Daylight Time

Arjan. Received on Mon Aug 17 1998 - 11:42:09 CDT

Original text of this message

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