Ticket #1326128 (closed Bugs: Fixed)

Opened 5 years ago

Last modified 5 years ago

UNIX_TIMESTAMP function does not exist in PostgreSQL

Reported by: nobody Owned by: nobody
Priority: 5 Milestone:
Component: Database Version: 0.1-alpha
Severity: Keywords:
Cc:

Description

fixed by adding the following functions I found at
http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html:
CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP
WITHOUT TIME ZONE)
RETURNS BIGINT
LANGUAGE SQL
IMMUTABLE STRICT
AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;';

CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP
WITH TIME ZONE)
RETURNS BIGINT
LANGUAGE SQL
IMMUTABLE STRICT
AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;';

Change History

Changed 5 years ago by roundcube

  • status changed from assigned to closed
Note: See TracTickets for help on using tickets.