[RESOLVED] Date & Time

[Robert_B_]

Hello again guys,

I'm formating the date and time from a date picker to mySQL and ok with the date. How can I ad the time to this?

$ad_date = explode("-", $_POST['ad_date']);
$formatDate = $ad_date[2]."-".$ad_date[1]."-".$ad_date[0];

Thanks

[laserlight]

You need to give more details, e.g., where is the time coming from, how you want it formatted, etc.

[Robert_B_]

Ooops,😃

I want to formatted to mySQL TIMESTAMP.
0000-00-00 00:00:00
and is coming from a javascript date picker from this place http://www.javascriptkit.com/script/script2/tengcalendar.shtml
the one with 12 hrs time
Thank you

[laserlight]

You probably could use [man]strtotime/man with [man]date/man, e.g.,

$formatDate = date('Y-m-d H:m:s', strtotime($_POST['ad_date']));

[Robert_B_]

Laserlight that's a fix

Thank you

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.

[Robert_B_]

I thought I did?

[laserlight]

Apparently not, otherwise there would be a [Resolved] tag in the thread title.

[Robert_B_]

Laserlight I had to changed to this format because the other one was inserting the minute 04 no matter what I put. This way is working.

Thanks again

$formatDate = date('Y-m-d h:i:s', strtotime($_POST['ad_date']));

[laserlight]

Oh yeah, that was a typo error on my part 🙂