save datetime in mysql using php

Question

I have table in mysql database which have field with datatype is datetime.

I want to save the datetime in this minute, for this I use " Now() ", but it does not work,

It just save 000000000000 in databaes.

Answer 1

INSERT ... (Now(), ...)

without additional quotes around the function Now()

Answer 2

date("g") this will return 12-hour format of an hour without leading zeros. For more options see http://php.net/manual/en/function.date.php

Answer 3

If you've got a timestamp in PHP check out FROM_UNIXTIME() http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime

$tstamp = time();

$query = "INSERT INTO `table` VALUES (FROM_UNIXTIME($tstamp))";

Answer 4

I would use function time() too, then it's easy to output different kind of timestamps with date().

$query = "INSERT INTO tbl VALUES (".time().");";