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!

current_timestamp

user382858Mar 22 2011 — edited Mar 22 2011

hi ,

i wanted to calculate 30 hours minus from current_timestamp

how would i do that
i.e. select current_timestamp - 1 from dual.In this i can minus 24 hours or one day

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2011

Added on Mar 22 2011

4 comments

478 views