...

View Full Version : how to store 3 seperat post values into a time field in a MySQL table



musher
08-23-2006, 04:00 PM
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

Fumigator
08-23-2006, 04:17 PM
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.

Kid Charming
08-23-2006, 04:23 PM
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'.

Fumigator
08-23-2006, 04:49 PM
Oooh I forgot about STR_TO_DATE; I like that answer a lot better!

musher
08-23-2006, 05:39 PM
Thanks guys, got it workin. Now all I need to make me happy is some cold weather and snow on the ground.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum