Re: Importing data w/ Unix timestamp - Mailing list 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