Why does the DATE() function return the next date after 6:00 PM?
I have a dataset with a Date and Time stamp field. When I convert it to a date field using DATE(`date_field`) I am finding some unexpected results.
The only way that I was able to get the intended results was to subtract 6 hours from the timestamp first:
Is this an intended function of the DATE() function, or am I doing something wrong?