Re: current_date, current_timestamp, sysdate, systimestamp

  • From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
  • To: jose.soares@xxxxxxxxxxxxxx
  • Date: Wed, 29 Apr 2015 11:04:00 -0400

On Wed, Apr 29, 2015 at 3:39 AM, Jose Soares <jose.soares@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2015