| From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, brianb-pggeneral(at)edsamail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Importing data w/ Unix timestamp |
| Date: | 2000-06-29 17:52:12 |
| Message-ID: | 395B8CCC.A2756957@austin.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas Lockhart wrote:
>
> > insert into RealTable select uname, timestamp(abstime(timeinAsInt4)),
> > duration, etc from TempTable;
>
> Another side comment: afaik an explicit conversion to abstime is not
> required to go from Unix time to timestamp. So
>
> insert into RealTable select uname, timestamp(timeinAsInt4),
> duration, etc from TempTable;
>
> should be equivalent.
Neat. BTW, the documentation on date/time functions at
http://www.postgresql.org/docs/postgres/x2876.htm
does not hint at this capability.
Regards,
Ed Loehr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitch Vincent | 2000-06-29 18:38:05 | Trigger question.. (Heaptuple struct) |
| Previous Message | Thomas Lockhart | 2000-06-29 17:42:00 | Re: Importing data w/ Unix timestamp |