Re: current_date, current_timestamp, sysdate, systimestamp
From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Wed, 29 Apr 2015 11:04:00 -0400
Message-ID: <CA+fnDAaw2RXaX73caRfr30pgMJa-=HzG_8ZVzW4GB_SU_2OOEg_at_mail.gmail.com>
On Wed, Apr 29, 2015 at 3:39 AM, Jose Soares <jose.soares_at_sferacarta.com> wrote:
> I suspect that current_date is not equal to sysdate and current_timestamp is
> not equal to systimestamp.
>
> Could someone explain me the difference between them?
Date: Wed, 29 Apr 2015 11:04:00 -0400
Message-ID: <CA+fnDAaw2RXaX73caRfr30pgMJa-=HzG_8ZVzW4GB_SU_2OOEg_at_mail.gmail.com>
On Wed, Apr 29, 2015 at 3:39 AM, Jose Soares <jose.soares_at_sferacarta.com> wrote:
> I suspect that current_date is not equal to sysdate and current_timestamp is
> not equal to systimestamp.
>
> Could someone explain me the difference between them?
current_* (or local*) returns the session timezone while sys* returns the db server/system timezone.
From the old 11.2 docs... see "Table 4-2 Additional Datetime Functions"
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch4datetime.htm#NLSPG253
-Jeremy
-- http://about.me/jeremy_schneider -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 29 2015 - 17:04:00 CEST