[SOLVED] Date/time help

[tejama]

Hey all,

 

I'm trying to insert a date/time into Mysql.  I'm entering a future date in a text box similar to '2007-12-31 6:00:00' and the field in Mysql I'm trying to insert it into is of the type datetime.

 

I'm trying

$date = $_POST['date'];

$newdate = date(Y-m-d H:i:s, strtotime($date);

 

Then I try to insert $newdate but no joy.  Can anyone suggest what's going wrong here?

[SycoSyco]

 

Try this, I think it's because you're missing quotes. Try echoing the query to the page first to see if you're getting the date in the format before trying to enter it. I'm presuming the date is a Unix timestamp too.

 

$newdate = date("Y-m-d H:i:s", strtotime($_POST['date']);

 

EDIT:

Ohhh you're entering the date into a field in the correct format? Then you can just enter it as shown below.

[The Little Guy]

This is how a DATETIME field is formatted in MYSQL:  YYYY-MM-DD HH:MM:SS

 

$query = "INSERT INTO table (`datetime`) VALUES ('{$_POST['date']}')";

$sql = mysql_query($query)or die(mysql_error());

[tejama]

Ahhh...right you are Little Guy.  Thanks for the help.

 

SycoSyco - made a typo and forgot to include the quotes...they were in my source code though.