| From: | Lucas Lain <lainl(at)aconectarse(dot)com> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: epoch to timestamp |
| Date: | 2003-05-12 15:05:44 |
| Message-ID: | 20030512120544.5bb9c4c6.lainl@aconectarse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
i really dont know how to do it ... i'm a newbie
it is something like this?
select cast(105471234 AS abstime) ...
and then?
On Fri, 9 May 2003 16:36:48 -0500
Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Fri, May 09, 2003 at 18:05:45 -0300,
> Lucas Lain <lainl(at)aconectarse(dot)com> wrote:
> >
> > can anyone tell me how to convert an epoch date to timestamp format??
>
> If the epoch date is an integer with seconds since the unix epoch,
> you can cast it to abstime and then to timestamp.
>
--
Lucas Lain
lainl(at)aconectarse(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randall Lucas | 2003-05-12 15:22:59 | Re: epoch to timestamp |
| Previous Message | scott.marlowe | 2003-05-12 14:58:16 | Re: Zope |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randall Lucas | 2003-05-12 15:22:59 | Re: epoch to timestamp |
| Previous Message | Didrik Pinte | 2003-05-12 12:38:15 | bad query performance |