Convert given time to seconds in jooq framework

Question

Suppose time is given in HH:MM:SS format.how can we convert this time to second in jooq.

example- Input Time - 2:10:30 outlet- 2*60*60 + 10*60 + 30 =7830 secs

Answer 1

This works in both MySQL and PostgreSQL, assuming you're using the TIME data type (otherwise, use DSL.time() to convert your data to SQL TIME):

with t(v) as (select time '02:10:30')
select extract(hour from v) * 3600
     + extract(minute from v) * 60
     + extract(second from v)
from t

jOOQ version:

hour(v).times(inline(3600))
  .plus(minute(v).times(inline(60)))
  .plus(second(v))

The following import is implied, as always:

import static org.jooq.impl.DSL.*;