which time period covers date string over datetime column 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

Thank you
A sargable exact alternative to DATE(ColumnName) = DATE'yyyy-mm-dd' is

ColumnName &gt;= TIMESTAMP'yyyy-mm-dd' AND
ColumnName &lt; TIMESTAMP'yyyy-mm-dd' + INTERVAL '1' DAY


Something like

ColumnName &gt;= 'yyyy-mm-dd 00:00:00' AND
ColumnName &lt;= 'yyyy-mm-dd 23:59:59'


is not only more complicated (and bug prone), but also leaves out any values between 'yyyy-mm-dd 23:59:59.000001' and 'yyyy-mm-dd 23:59:59.999999'.