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