Forum Academy Marketplace Showcase Pricing Features

SQL database connector issue with DATE

I can’t get the correct result by the “codes” below:
what did I do wrong? is it because the date format different between 12/01/2021 and 2021-12-01?

Hi,
Better format the date into unix in query.
Exampel :
UNIX_TIMESTAMP(STR_TO_DATE(ETD’%M %e %Y %h:%i%p’))

After that you can simply convert string into date format in bubble.

SQL Database Connector issue: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:%i%p’)) ETD from awb4cnee where etd >= ‘12/01/2021’ limit 20’ at line 1

SQL Database Connector issue: Incorrect parameter count in the call to native function ‘STR_TO_DATE’