DataQueryBuilder with Date & Time function

Data Service
1

Application ID

F20A5DDC-36F3-5EFA-FF8E-C4FFCB5AA300

I’m using DataQueryBuilder in my Service (Java), but I stuck with Date Time functions.

When I use:

CURRENT_TIMESTAMP()
CURDATE()
CAST(‘2020-05-29 20:37:21’ AS DATETIME)
CONVERT(‘2020-05-29 20:34:42’, DATETIME)

in my whereClause

I got error: 1007.

I want to do a very simple thing: compare some column with current date

How to do this? Could you provide MySQL version? or may be it’s restriction in core code?

2

Hi Dmitry,

You can see a list of available options for date related operations here:
https://backendless.com/docs/android/data_search_with_dates.html

If you could describe a specific condition you’d like to use in your query, I’ll be happy to make a suggestion.

Regards,
Mark

3

Thanks for the link. My problem solved.