Message-Id: <10558.112100@fatcity.com> From: MTPConsulting@aol.com Date: Fri, 14 Jul 2000 14:58:16 EDT Subject: Re: time zone Sysdate on server uses date/time of server. Sysdate on Forms 4.5 and 6, Sqlplus, uses server date/time. Sysdate in SQL on Forms 5.0 uses server date/time. Sysdate in PL/SQL on Forms 5.0 uses CLIENT date/time. $$DATE$$ in all Forms versions uses CLIENT date/time; $$DBDATE$$ uses server date/time. Time zone has no effect. The time zone function in SQL merely adds/subtracts hours but does not take into account Daylight Savings/Summer time. You're on your own there. Marc Perkowitz MTP Systems Consulting, Ltd. In a message dated 7/12/00 11:47:08 AM Central Daylight Time, alex_hillman@physia.com writes: << 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 >>