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 `datetime` function (sqlite) #53

Closed cyberhuman closed 6 years ago

cyberhuman commented 6 years ago

See https://www.sqlite.org/lang_datefunc.html for reference.

As of now, only the following form is needed:

SELECT datetime(1092941466, 'unixepoch');
ygrek commented 6 years ago

Cannot express multi-type function signatures for now (in this case datetime first arguments can be float or string), but will exploit the fact that datetime accepts timestamp in string representation too. In general, currently datetime type story is not very defined..