Re: How to get current GMT time
From: Antun Domitrovic <antun.domitrovic_at_zg.tel.hr>
Date: Mon, 4 Jan 1999 15:24:30 +0100
Message-ID: <76qiqj$odt$1_at_as102.tel.hr>
Date: Mon, 4 Jan 1999 15:24:30 +0100
Message-ID: <76qiqj$odt$1_at_as102.tel.hr>
Gavin Ho wrote in message <76k3ja$hec6_at_news.hk.linkage.net>...
>Hi,
>
>I already browsed through Oracle's doc but still can't find the answer.
>Anyone can help me?
>
>My question is: how to get current GMT time using oracle sql.
>
>Thank you
>
>Gavin
>
Hi Gavin
Try using date fuction NEW_TIME(date_and_time_in_z1, z1, z2).
z1 and z2 are abbreviations of time zones.
Antun Received on Mon Jan 04 1999 - 15:24:30 CET