Oracle Database Discussions

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!

How to select data from table having date in timestamp

kumar12May 27 2009 — edited May 28 2009

hi All,

I have table and having one field date in type (Timestamp(6))

Date Timestamp(6)

I want to select the data from this table for yesterday or current date or someother day

Please let me know the query for the same.

Regards
Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2009

Added on May 27 2009

#general-database-discussions

18 comments

2,918 views