| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, Lucas Lain <lainl(at)aconectarse(dot)com> |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: epoch to timestamp |
| Date: | 2003-05-12 15:26:30 |
| Message-ID: | 84320000.1052753190@lerlaptop.iadfw.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
--On Monday, May 12, 2003 18:30:11 -0200 Achilleus Mantzios
<achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> On Mon, 12 May 2003, Lucas Lain wrote:
>
>> i really dont know how to do it ... i'm a newbie
>> it is something like this?
>>
>> select cast(105471234 AS abstime) ...
>>
>> and then?
>
> Just do
> select 105471234::abstime::timestamp;
>
Along the same lines, how can I get from seconds to hour/minute/seconds?
(an interval?)
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucas Lain | 2003-05-12 15:27:05 | Re: epoch to timestamp |
| Previous Message | Randall Lucas | 2003-05-12 15:22:59 | Re: epoch to timestamp |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucas Lain | 2003-05-12 15:27:05 | Re: epoch to timestamp |
| Previous Message | Randall Lucas | 2003-05-12 15:22:59 | Re: epoch to timestamp |