how to store 3 seperat post values into a time field in a MySQL table

I am setting up a form to except time I've set up 3 drop down boxes
- Hour (1 - 12)
- Min (15, 30, 45)
- AM or PM

what's the best way to get these three post values into a format to store in a MySQL time field

Here are your options:

http://dev.mysql.com/doc/refman/4.1/en/time.html

I didn't see an option to specify AM/PM so I'm assuming you'll need to do something like add 12 to the hour if PM is selected.

Concatenate your values and use MySQL's STR_TO_DATE function as you insert:


INSERT INTO
table
(timecol)
VALUES
(STR_TO_DATE('12:15 AM','%l:%i %p'))


That time will be inserted as '00:15:00'.

Oooh I forgot about STR_TO_DATE; I like that answer a lot better!

Thanks guys, got it workin. Now all I need to make me happy is some cold weather and snow on the ground.