Format a string into mysql datetime

[yoda699]

Hey,

So I got a form that requires the user to insert: the hour, the minuets, and if its AM or PM.

what I get is three variables:

$hour

$minuets

$amPm

 

Those variables are combined into a string.

I need to convert this somehow to readable format for mysql server and insert the data. I found loads of function to convert date from mysql into strings, but not the other way around. Any suggestions about this issue?

 

Thanks,

[dgoosens]

in MySQL make the data DATETIME

 

in PHP

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

(for instance)

 

http://uk.php.net/manual/en/function.date.php

[Mchl]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

[yoda699]

STR_TO_DATE is an mysql function.

is there a php equivalent?

 

 

[thebadbad]

Something like

 

echo date('H:i:s', strtotime('03:50 PM'));

?

[Mchl]

Since you want to put in MySQL, I thought MySQL function will work for you

 

thebadbad's solution should work