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 FROM_UNIXTIME #50

Closed cyberhuman closed 6 years ago

cyberhuman commented 6 years ago

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_from-unixtime

ygrek commented 6 years ago

Returns a representation of the unix_timestamp argument as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context

sqlgg is not very ready for such advanced typing, so it will be partial support first

cyberhuman commented 6 years ago

I'm primarily interested in using it with INSERT, so the type of the returned value does not really matter.