Dates about sql ORACLE

• antoine_mc1

  Valued Member

  Points: 64

  More actions

  November 21, 2023 at 9:39 pm

  #4332018

  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

• frederico_fonseca

  SSCoach

  Points: 16218

  More actions

  November 21, 2023 at 9:45 pm

  #4332023

  this isn't a Oracle forum - so you would be better off asking elsewhere dedicated to Oracle.

  but (assuming this ain't spam) the answer is no there isn't a better way.