Post reply

BETWEEN DATETIME STATEMENT NOT WORKING

  • October 2, 2024 at 2:07 pm

    #4464532

    I am using the follow segment in my query, but it is only running the query by date :-

    (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')

    I have results that are on the same day but different times, so my query must return by date and time, but I am getting multiple results indicating it is only querying the date element and not the time.  Any help pppllleeeaaassseee

    Attachments:
    You must be logged in to view attached files.

  • October 2, 2024 at 2:28 pm

    #4464542

    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.

  • October 2, 2024 at 3:10 pm

    #4464553

    Maybe one to post on an actual Oracle forum also.

    Everyone here will be primarily Microsoft SQL Server focused, not to say that there may not be a few Oracle people around, just they will be very few and far between.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply