I just sent some time wondering data was not the same in a query result with a date comparison. The query had an entry like
.gt(some_dt_column, some_date_variable)
The ‘some_date_variable’ was set to a new date with the time 0.
The problem was the data was GMT and the people not seeing it was also GMT. When I put my timezone in GMT I had it too. No since there was no time in the db, I set it to ‘ge’ instead of ‘gt’.
Question:
Why would my time give data when it was set as above, if all the entries have the time 00:00 and I put the date ‘some_date_variable’ to ‘(0,0,0,0)’. I would really like to know what WIX has implemented on timezones. This can cause nice headaches to find, especially with different timezones and users are not in the same as the builders/developers