search

ygrek / sqlgg

SQL Guided (code) Generator
https://ygrek.org/p/sqlgg/
GNU General Public License v2.0
62 stars 20 forks source link

add support for DATE(), TIME() #84

Closed cyberhuman closed 4 years ago

cyberhuman commented 4 years ago

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_time I see some mentions of these functions in sql.ml but it doesn't work because apparently DATE and TIME are recognized as column types.

ygrek commented 4 years ago

meh, in sqlite workaround with quoting works, but not in mysql :

MariaDB [(none)]> select `date`(current_timestamp);
ERROR 1305 (42000): FUNCTION date does not exist