November 21, 2023 at 9:42 pm
I have the following Oracle sql script, I only need all the records from yesterday.
and fch_date >= TRUNC(SYSDATE -1)
and fch_date < TRUNC(SYSDATE)
This is another sql oracle statement
and fch_date BETWEEN TRUNC(SYSDATE - 1)
and trunc(sysdate) - internal '1' SECOND
Is there a better way to have only all the records from yesterday? Thanks for your help
I want to have all the records from yesterday but all without missing any records
November 21, 2023 at 10:07 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy