Importing data w/ Unix timestamp
От | brianb-pggeneral@edsamail.com |
---|---|
Тема | Importing data w/ Unix timestamp |
Дата | |
Msg-id | 20000629073316.9274.qmail@mail01.edsamail.com.ph обсуждение исходный текст |
Ответы |
Re: Importing data w/ Unix timestamp
Re: Importing data w/ Unix timestamp |
Список | pgsql-general |
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 -- Brian Baquiran <brianb@edsamail.com> http://www.baquiran.com/ AIM: bbaquiran Work: (632)7182222 Home: (632)9227123
В списке pgsql-general по дате отправления: