I have a form where users select a time from a form
<select name='hour'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
<option value='6'>6</option>
<option value='7'>7</option>
<option value='8'>8</option>
<option value='9'>9</option>
<option value='10'>10</option>
<option value='11'>11</option>
<option value='12'>12</option>
</select>
:
<select name='min'>
<option value='00'>00</option>
<option value='15'>15</option>
<option value='30'>30</option>
<option value='45'>45</option>
</select>
<select name='ampm'>
<option value='AM'>AM</option>
<option value='PM'>PM</option>
</select>
I'm posting this information to a processing page where I need to save the time that the user submitted in the database in DateTime format. The data will need to be stored in the database in the datetime format (2011-06-11 23:11:07) with the date being today's date.
I'm thinking that the data function will some how be able to convert it, but I can't seem to figure it out.