3 CREATE FUNCTION SEC_TO_TIME(timestamp with time zone)
4 RETURNS timestamp with time zone AS $$
5 select date_trunc('second', $1);
8 CREATE FUNCTION SEC_TO_TIME(bigint)
10 select date_trunc('second', $1 * interval '1 second');
13 CREATE FUNCTION UNIX_TIMESTAMP(timestamp with time zone)
14 RETURNS double precision AS $$
15 select date_part('epoch', $1);
18 CREATE FUNCTION SEC_TO_INT(interval)
19 RETURNS double precision AS $$
20 select extract(epoch from $1);