Question about SYSDATE and the local TimeZone.
Date: Mon, 16 May 1994 09:51:12 GMT
Message-ID: <Cpw3DE.Lvy_at_zeus.etsimo.uniovi.es>
Does anybody know which timezone sysdate selects to return the date?
We are in Europe and use MET-1METDST as out local timezone . When I use
SYSDATE to insert dates in a field, I would like to insert GMT times.
Does anybody know how may I change the timezone used by SYSDATE without
change our server timezone?
I thought of using NEW_TIME to force the conversion, but there is no
MET timezone and it would be difficult to know when to use MET or METDST
(when daylight saving is in effect).
--
+---------------------------------------------------------------------------+
+ Fernando Ariznavarreta Fernandez
E-Mail:fernando_at_afrodita.etsimo.uniovi.es +
+ Dpto. Explotacion y Prospeccion de Minas Phone: +34 8 510 4267 +
+ Advance School of Mines. University of Oviedo +34 8 510 4336 +
+ Independencia, 13 Fax: +34 8 510 4242 +
+ Oviedo 33004, SPAIN +34 8 510 4340 +
+---------------------------------------------------------------------------+
Received on Mon May 16 1994 - 11:51:12 CEST