Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dates
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 TimeGMT Greenwich Mean Time
Arjan. Received on Mon Aug 17 1998 - 11:42:09 CDT
![]() |
![]() |