Re: Importing data w/ Unix timestamp

brianb-pggeneral@edsamail.com writes:

>
> I want to copy in some data from a tab-delimited flat file, but one of the
> columns that should translate into a datetime is in Unix timestamp format
> (seconds since epoch).
>
> The data should go into this table:
> create table logins (
>     uname varchar(100),
>     timein datetime,
>     duration int,
>     cid varchar(20),
>     natip varchar(20)
> );
>
> But it looks like this in the comma-delimited flatfile:
>
> bob     957974401    17    8325824    210.16.68.250
> james     957974401    13    3737270    210.16.68.250
> edwin    957974402    201    3672136    210.16.68.250
> steph    957974404    25    9398998    210.16.68.250
> mitch    957974406    7    7221757    210.16.68.250

I forgot to mention that the error returned is:
ERROR:  copy: line 1, Bad timestamp external representation '957974401'

Thanks,
Brian
--
Brian Baquiran <brianb@edsamail.com>
http://www.baquiran.com/ AIM: bbaquiran
Work: (632)7182222       Home: (632)9227123