parsedatetime/lsparsedatetime will convert it for you On 6/2/06, Les Mizzell <[EMAIL PROTECTED]> wrote: > > Les Mizzell wrote: > > Having some problems getting a time inserted correctly into mySQL > > > OK, I get what the problem is - mySQL uses a 24 hour clock, not 12 hour > clock. So, I don't thing allowing input into the field as "1:15 PM" will > work without a lot of extra coding to convert that to "13:15" before it > hits the database. > > Best solution seems to be a dropdown with values like: > > <selection value="13">1 PM</selection> > <selection value="14">2 PM</selection> > > > Anybody got a better idea? > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
