jOOQ
jOOQ copied to clipboard
Add support for DSL.epoch in Firebird
We can calculate the EPOCH of a timestamp in Firebird, e.g. using:
SELECT DATEDIFF(second, TIMESTAMP'1970-01-01 00:00', CURRENT_TIMESTAMP)
FROM RDB$DATABASE
See: https://stackoverflow.com/a/27858817/521799
We first need a TIMESTAMPDIFF(DatePart, Field, Field) method (see #7900)