Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYSDATE Vs CURRENT_DATE

733256Apr 29 2011 — edited Apr 29 2011
select sysdate,current_date from dual;
select sysdate - current_date from dual;

the result of first query is same and second one return zero..what is the difference between them??when we are used sysdate or current_date??plzzz help me..
This post has been answered by Ganesh Srivatsav on Apr 29 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2011
Added on Apr 29 2011
#plsql
4 comments
6,895 views