Message-Id: <10556.111815@fatcity.com> From: Alex Hillman Date: Wed, 12 Jul 2000 11:23:06 -0400 Subject: time zone This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFEC15.14C2AA40 Content-Type: text/plain; charset="iso-8859-1" Could somebody explain to me how Oracle resolve time zone problem. My understanding is that Oracle keep dates in GMT. How it convert let say sysdate? Using time zone of the server, of the client. How it convert time zone in DML?, using time zone of the client? Alex Hillman ------_=_NextPart_001_01BFEC15.14C2AA40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable time zone

Could somebody explain to me how = Oracle resolve time zone problem. My understanding is that Oracle keep = dates in GMT. How it convert let say sysdate? Using time zone of the = server, of the client. How it convert time zone in DML?, using time = zone of the client?

Alex Hillman

------_=_NextPart_001_01BFEC15.14C2AA40--