Dates about sql ORACLE

• antoine_mc1

  Valued Member

  Points: 64

  More actions

  November 21, 2023 at 9:42 pm

  #4332020

  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

• ratbak

  Ten Centuries

  Points: 1358

  More actions

  November 21, 2023 at 10:07 pm

  #4332035

  Duplicate of https://www.sqlservercentral.com/forums/topic/dates-about-sql-oracle