My question is a restlessness I been having for a time. So, here it goes:
If I have a datetime column and perform a date search without the time 'yyyy-mm-dd' in a between statement. Which period of time does the query covers?. From this, I can figure some others like timezone related or daylights changes.
So, have you any knowledge or source to check this information?
I know this is not the kind of filter to apply in a datetime column but due a human mistake in a query once I still have doubts