October 2, 2024 at 2:07 pm
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
October 2, 2024 at 2:28 pm
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
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
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