Hello Experts,
If I run my sql queries (extracts) with below condition at 08:00:00 on April 1, 2021:
BETWEEN to_date('20210101', 'YYYYMMDD') and sysdate -1
The condition will be false for values on March 31, 2021 that are later than 08:00:00 (upper boundary sysdate -1 will be till March 31, 2021 -08:00:00 AM and not after that)?
If yes then how can I modify the query to ensure that it fetches all records till date March 31, 2021 , regard less of time stamp.
Thanks,
Rajneesh