Hello! I am trying to query my database for entries with a specific date.
The format should be correct, but when I use the following clasuse 'timeArrived > ‘05/24/2023 23:59:59’ AND timeArrived < ‘05/26/2023 00:00:00’ I expected to get back whatever record that has the date 05/25/2023, but that wasn’t the case. Am I missing something?
Very strange. Is there a way to construct a where-clause that only checks the month, day and year while disregarding time entirely? Using the clause timeArrived >= ‘05-25-2023 00:00:00’ AND timeArrived <= ‘05-25-2023 23:59:59’ I get records for that date, but also some records for the next day. Could it be time zone difference that does this and how can I account for that?