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!

need to get rows created 30 days ago

ElMazzaXNov 29 2011 — edited Nov 29 2011

hi all!

i got a table with a "creationDate" column (of type Date).

what i need is to find out all rows that were created 30 days ago.

i tried somwthing like sysdate - column but i'm not finding the answer...

many thanks to everyone! ;)

This post has been answered by €$ħ₪ on Nov 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2011

Added on Nov 29 2011

9 comments

775 views