Converting String to DateTime in PHP

Question

I need to insert the datetime value entered from the HTML form using PHP into the MySQL database. However I receive the Incorrect datetime value error each time I try to execute the code below,

$rosterstartdate=$_GET['rosterstartdate'];
$rosterenddate=$_GET['rosterenddate'];

//$date = date_create_from_format('d/M/Y:H:i:s', $rosterstartdate);
//$date->getTimestamp();
//echo $date;

$date = strtotime($rosterstartdate);
echo date('d/M/Y H:i:s', $date);

    // echo DATE_FORMAT($rosterstartdate,"%Y%m%d %H%i%s");

    $con=mysql_connect("localhost","root","");  
    if($con==true){
        mysql_select_db("attendance_db",$con);
        $query="insert into tblroster values(LAST_INSERT_ID(),'$rosterteam','$rostershifts','$date','$rosterenddate')";

I have tried using each of the different techniques above to do the conversion but it does not work. Any ideas on how this could be inserted

What is the exact error you are getting? Would you post the output of 'describe tblroster;' ? — walrii
– walrii, Commented Jul 22, 2012 at 8:32
Incorrect datetime value: '1341926751' for column 'rosterstartdate' at row 1 — Yoosuf
– Yoosuf, Commented Jul 22, 2012 at 8:33

David Stetler · Accepted Answer · 2012-07-22 09:03:41Z

2

try this:

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

Instead of echoing it out, use that code to format the date.

However, it looks like what you really want is this:

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

This way you can just reference those two variables in your query string.

answered Jul 22, 2012 at 9:03

David Stetler

1,46110 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tufan Barış Yıldırım · Accepted Answer · 2012-07-22 09:22:04Z

0

You don't need to format it if you have a unixtime use FROM_UNIXTIME,
change your query as

    $rosterstartdate=$_GET['rosterstartdate'];
$rosterenddate=$_GET['rosterenddate'];

//$date = date_create_from_format('d/M/Y:H:i:s', $rosterstartdate);
//$date->getTimestamp();
//echo $date;

$date = strtotime($rosterstartdate);

    $con=mysql_connect("localhost","root","");  
    if($con==true){
        mysql_select_db("attendance_db",$con);
        $query="insert into tblroster values(LAST_INSERT_ID(),'$rosterteam','$rostershifts',FROM_UNIXTIME($date),'$rosterenddate')";

answered Jul 22, 2012 at 9:22

Tufan Barış Yıldırım

3,97228 silver badges37 bronze badges

Collectives™ on Stack Overflow

Converting String to DateTime in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related