Re: Importing data w/ Unix timestamp

brianb-pggeneral(at)edsamail(dot)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(at)edsamail(dot)com>
http://www.baquiran.com/ AIM: bbaquiran
Work: (632)7182222 Home: (632)9227123