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 по дате отправления: