Skip to Main Content

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 functioning

Arun NJun 22 2014 — edited Jun 22 2014

Hi,

This two cols giving same results , dunno why ?. Can anyone explains to me

select sysdate, sysdate-4/24 from dual;

SYSDATE   SYSDATE-4/24

--------- ------------

22-JUN-14 22-JUN-14                                 

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2014
Added on Jun 22 2014
6 comments
1,035 views