Ticket #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
Note: See
TracTickets for help on using
tickets.
