I would like to have support for FROM_UNIXTIME() function, as available in MySQL: https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_from-unixtime
Some background about this feature request. I perfectly understand that SQLite is not MySQL, that FROM_UNIXTIME is a function currently only available in MySQL , and that the equivalent in SQLite is to use the "unixepoch" modifier in date and time function. ProxySQL (https://github.com/sysown/proxysql/) is a proxy for MySQL , and it uses SQLite (currently bundled) to store configuration and export metrics using a MySQL interface built on top of SQLite iself. A feature request for ProxySQL was to have FROM_UNIXTIME() available ( https://github.com/sysown/proxysql/issues/758), and this was made available in: * for SQLite 3.15 : https://github.com/sysown/proxysql/commit/b49966a8509f2c85e2507534ed6f1843a654ac81 * for SQLite 3.19 : https://github.com/sysown/proxysql/blob/312a04c73dafc6f5c23bb308c1a70b5f3728899e/deps/sqlite3/from_unixtime.patch It is being discussed in https://bugzilla.redhat.com/show_bug.cgi?id=1457929 about de-bundling SQLite from ProxySQL , and having this feature upstream (SQLite) should allow to de-bundle the two softwares. Would you accept (or improve) the function FROM_UNIXTIME as implemented in https://github.com/sysown/proxysql/blob/312a04c73dafc6f5c23bb308c1a70b5f3728899e/deps/sqlite3/from_unixtime.patch ? Thanks, René _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
