Re: What is the current local time zone ?
From: Paul Eggert <eggert_at_twinsun.com>
Date: 1997/10/14
Message-ID: <621e10$hc8$1_at_tattoo.twinsun.com>#1/1
Date: 1997/10/14
Message-ID: <621e10$hc8$1_at_tattoo.twinsun.com>#1/1
AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> writes:
>select NEW_TIME(DATE,'TIME ZONE YOU ARE IN', TIME ZONE YOU WANT') FROM DUAL;
>AST Atlantic Standard Time
>BST Bering Standard Time
...
Does Oracle really limit itself to obsolescent and ambiguous abbreviations like that? For example, Bering Standard Time hasn't been used since October 1983, and these days BST typically stands for British Summer Time (which is 1 hour ahead of GMT).
Surely Oracle has better support for time zones than this. Received on Tue Oct 14 1997 - 00:00:00 CEST