Opened 8 years ago

Closed 7 years ago

#1326128 closed Bugs (Fixed)

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 (1)

comment:1 Changed 7 years ago by roundcube

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