poleposters Posted August 27, 2009 Share Posted August 27, 2009 Hi, Whats the best way to handle a date range in mysql? ie I'm building a list of events. Some of the events can last an entire week rather than one day.e.g September 1 to September 7. Is it possible to store a date range in a single field? Or is conventional apporach to have seperate fields for the start date and the finish date. Any advice is appreciated. Cheers. Link to comment https://forums.phpfreaks.com/topic/172073-how-do-i-best-handle-a-date-range-in-mysql/ Share on other sites More sharing options...
Mark Baker Posted August 27, 2009 Share Posted August 27, 2009 Use a start date field and an end date field, and use date or timestamp types rather than VARCHAR2 Link to comment https://forums.phpfreaks.com/topic/172073-how-do-i-best-handle-a-date-range-in-mysql/#findComment-907481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.