Re: Importing data w/ Unix timestamp

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, brianb-pggeneral(at)edsamail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing data w/ Unix timestamp
Date: 2000-06-29 17:42:00
Message-ID: 395B8A68.CCEEE831@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

- Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-06-29 17:52:12 Re: Importing data w/ Unix timestamp
Previous Message Bruce Momjian 2000-06-29 16:27:47 Re: Comments with embedded single quotes