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.
-
2Can you please provide the code?Ivan Nevostruev– Ivan Nevostruev2009-12-07 20:52:47 +00:00Commented Dec 7, 2009 at 20:52
-
2Please take the time to use correct spelling and grammar if you want people to help you. Then, post your code snippet of SQL or PHP.philfreo– philfreo2009-12-07 20:53:22 +00:00Commented Dec 7, 2009 at 20:53
-
2And accept your answer if you wish that we will help you!Jan Hančič– Jan Hančič2009-12-07 20:54:48 +00:00Commented Dec 7, 2009 at 20:54
-
Table structure can also helpIvan Nevostruev– Ivan Nevostruev2009-12-07 21:43:01 +00:00Commented Dec 7, 2009 at 21:43
Add a comment
|
7 Answers
If you use php, the correct format is:
date("Y-m-d H:i:s");
UPDATE:
Minutes are expressed as i not m
1 Comment
Deproblemify
I always use this too... nice to see that other people use this way too.
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))";
Comments
INSERT ... (Now(), ...)
without additional quotes around the function Now()
Comments
I would use function time() too, then it's easy to output different kind of timestamps with date().
$query = "INSERT INTO tbl VALUES (".time().");";
Comments
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
Comments
An example of a PHP script which sets a date in MySQL manually,
<?php
$query_date = "INSERT INTO tablename (col_name, col_date) VALUES ('DATE: Manual Date', '2008-7-04')”;
mysql_query($query_date) or die(mysql_error());
?>
An example of a PHP script which sets a date in MySQL Automatic,
<?php
$query_date = "INSERT INTO tablename (col_name, col_date) VALUE ('DATE: Auto CURDATE()', CURDATE() )”;
mysql_query($query_date) or die(mysql_error());
?>
Comments
try this: set the 'type' of column named 'date_time' as 'DATETIME' and run the following query:
INSERT INTO my_table (date_time) VALUES (CURRENT_TIMESTAMP)
