Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Best data type for drop down of hours and days
imagined - 4:00 pm on Jul 29, 2010 (gmt 0)
I need the user to select the minimum appointment lead time, to ensure that we receive adequate notice of new appointments before the client arrives. It can range from 4 hours to 2 days.
So in the drop-down menu I will include:
2 days1 day8 hours4 hours2 hours1 hour
What is the best way to store that information on the database? What data type?
Timestamp? Time?
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4178638.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com