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.
