jOOQ icon indicating copy to clipboard operation
jOOQ copied to clipboard

Add support for DSL.epoch in Firebird

Open lukaseder opened this issue 5 years ago • 1 comments

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

lukaseder avatar Jun 04 '20 10:06 lukaseder

We first need a TIMESTAMPDIFF(DatePart, Field, Field) method (see #7900)

lukaseder avatar Jun 04 '20 10:06 lukaseder