[PostgreSQL] select UNIX TimeStamp

[Pay Liu]

Hi Lukas and all,

I use sql-plain to get unix time as below.

SQL:
select EXTRACT(epoch FROM now()) as unix_time (function datetime - 
epoch<http://www.postgresql.org/docs/9.2/static/functions-datetime.html>
)

JOOQ:

Factory.field("EXTRACT(epoch FROM now())", Integer.class)

I found  Factory.extract(), it seem similar, but not. 

Can it be perfect or use sql-plain is one of solutions now?

Thanks.
-Pay