On 2$B7n(B28$BF|(B, $B2<8a(B6$B;~(B48$BJ,(B, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 28 Feb 2008 11:43:18 +0100, howa <howac...@gmail.com> wrote:
> > CREATE TABLE `table1` (
> > `ts` TIMESTAMP NOT NULL
> > ) ENGINE = innodb;
>
> > INSERT INTO `table1` (`ts`) VALUES ('1202832067');
> > INSERT INTO `table1` (`ts`) VALUES ( UNIX_TIMESTAMP('1202832067') );
>
> > The table result is storing "0000-00-00 00:00:00" for both queries,
> > any idea?
>
> Because MySQL doesn't automatically convert an integer to a datetime
> string.
> INSERT INTO `table1` (`ts`) VALUES ( FROM_UNIXTIME('1202832067') );
> --
> Rik Wasmus

Hello, If I have millions of row of UNIX timestamps to insert, I don't
want to invoke the method everytime, are there any faster method?

Thx