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!

Getting date between the SYSTIMESTAMP.

736579Apr 27 2010 — edited Apr 27 2010

Hi,

I am trying pull the data from the table between the systimestamp and I am getting the missing right parenthesis error.

select count(*) from test_track
where track_date
between
(
(TO_DATE(SYSTIMESTAMP) + NUMTODSINTERVAL(0,'HOUR'))
and
(TO_DATE(SYSTIMESTAMP) + NUMTODSINTERVAL(11,'HOUR'))
)

I am trying to kick in a job daily at 11:00 night and I want to pull the data from early morning to 11:00 P.M. Any help is appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2010

Added on Apr 27 2010

3 comments

1,241 views