From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ericson Smith <eric(at)did-it(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unixtime (epoch) into timestamp? |
Date: | 2002-09-27 02:44:33 |
Message-ID: | 20204.1033094673@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ericson Smith <eric(at)did-it(dot)com> writes:
> Just added this handy little function to our catalog based on that
> answer:
> CREATE FUNCTION "fn_date"(int4) RETURNS timestamp with time zone AS
> 'DECLARE
> my_epoch ALIAS FOR $1;
> my_ret timestamp;
> BEGIN
> SELECT INTO my_ret "timestamp"(my_epoch);
> RETURN my_ret;
> END;' LANGUAGE 'plpgsql';
Better make that
SELECT INTO my_ret "timestamptz"(my_epoch);
else it will break in 7.3 --- "timestamp" is going to start meaning
"timestamp without time zone", per SQL spec. Likewise my_ret had
better be explicitly declared timestamptz or timestamp with time zone.
Otherwise looks good.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-27 02:52:17 | Re: get date in binary number format |
Previous Message | Scott Chapman | 2002-09-27 02:40:37 | Re: SQL subquery to supply table name? |