Data Warehousing and Business Intelligence

2 January 2013

Difference between CURRENT_DATE and SYSDATE

Filed under: Oracle BI — Vincent Rainardi @ 10:38 am

The difference between CURRENT_DATE and SYSDATE is:
CURRENT_DATE is the client’s time zone
SYSDATE is server’s time zone

i.e. if you are in London and your Oracle database server is in New York:
CURRENT_DATE: 02/01/2013 10:26:25
SYSDATE: 02/01/2013 05:26:25

Advertisements

Create a free website or blog at WordPress.com.