Jump to content

How do I best handle a date range in mysql?


poleposters

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.