Data Warehousing and Data Science

2 January 2013

Difference between CURRENT_DATE and SYSDATE

Filed under: Oracle — 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

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: