BETWEEN DATETIME STATEMENT NOT WORKING

• FraserGus

  SSC Veteran

  Points: 273

  More actions

  October 2, 2024 at 1:53 pm

  #4464518

  I am using the below segment in my query :-

  to_date(PROCESS_DATE, 'dd/mm/yyyy hh24:mi:ss'))

  BETWEEN to_date(START_DATE, 'dd/mm/yyyy hh24:mi:ss') and

  to_date(END_DATE, 'dd/mm/yyyy hh24:mi:ss')

  but it seems to be ignoring the time part, as it is returning both the below results, which seems to indicate it is only looking at the date element, rather than date and time, hence returning both results.

• ratbak

  Default port

  Points: 1416

  More actions

  October 2, 2024 at 2:28 pm

  #4464541

  4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.