I read WAY too much into “ANSI 92.” Spent time looking at how ANSI 92 DATETIME data types are supposed to work.
Despite looking like datetime data coming back in the JSON response, it looks like Backendless stores datetime values in very novel ways in the backend, or at least as accessed in dataQuery.condition where clauses.
Please share some sort of information about how datetimes work in Backendless.
I’m wasting a lot of time guessing due to a lack of documentation. I never would have guessed I need to do this off of either inspecting the JSON coming back or reading documentation that the dataQuery.condition is:
“Search with query - a query is an SQL-92 expression (the where clause) referencing data object properties.”
I’d love to help, but I need to ask for a clarification. Your original question was: “How do I create a query that gives items where the date is within the 24 hours of today?”
My question is “when is today?”. Is it in the timezone of the client or the server? The client could be in any time zone and when it sends a request to the server, it could specify the time relative to where the client app is running.