In my data I have a mix of timestamps and dates. When I floor this to try and return all entries at dates. It appears only the entries that are dates in the original data are returned. None of the timestamp entries show.
date(floor([Completed Date]),'MM/DD/YYYY') as [Completed Date]
SET TimeFormat='h:mm:ss TT';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
I tried changing that and it still only returns the dates that show in the data as a date. All timestamps are not shown. Just to be clear the original data has both dates and timestamps in the same field.