October 2, 2024 at 1:53 pm
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.
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.
Viewing 2 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