I have started working with the Blog and PrivateMembersData collections, and am a bit confused about how date/time fields are handled. It appears that the date/time fields in these collections are always in GMT (Z) format. When displayed in the Data Manager, the date/time fields appear in local time (in my case US Central Time). However, when retrieved using wixData.query, they remain in GMT format. That could be confusing.
What might be even more confusing is if someone is comparing a user entered date or date picker selection to a date in one of these collections. The entered or selected date will be local, but the collection date will be GMT. Without converting the dates to the same region, the code will never work.
Not sure if this behavior is documented anywhere; if not, it should be.