Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sysdate from dual ;
- > 30-APR-19
- SELECT
- count(*)
- FROM
- event_log
- WHERE
- edate between to_date('04232019', 'MMDDYYYY') and to_date('04292019', 'MMDDYYYY') ;
- > 1156
- SELECT
- count(*)
- FROM
- event_log
- WHERE
- edate between (sysdate-7) and (sysdate-1) ;
- > 1276
- SQL> select sysdate,
- 2 sysdate - 7 prev_week,
- 3 sysdate - 1 yesterday
- 4 from dual;
- SYSDATE PREV_WEEK YESTERDAY
- ------------------- ------------------- -------------------
- 30.04.2019 23:13:14 23.04.2019 23:13:14 29.04.2019 23:13:14
- SQL>
- SQL> select trunc(sysdate) today,
- 2 trunc(sysdate - 7) prev_week,
- 3 trunc(sysdate - 1) yesterday
- 4 from dual;
- TODAY PREV_WEEK YESTERDAY
- ------------------- ------------------- -------------------
- 30.04.2019 00:00:00 23.04.2019 00:00:00 29.04.2019 00:00:00
- SQL>
- where edate between trunc(sysdate-7) and trunc(sysdate-1) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement