# Event duration, what is more effective start datetime end datetime, or 1 hr long?

**URL:** <https://forum.kirupa.com/t/event-duration-what-is-more-effective-start-datetime-end-datetime-or-1-hr-long/299772>\
**Category:** programming\
**Created:** [November 10, 2009, 8:17pm UTC](https://forum.kirupa.com/t/event-duration-what-is-more-effective-start-datetime-end-datetime-or-1-hr-long/299772 "2009-11-10T20:17:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imagined](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@imagined](https://forum.kirupa.com/u/imagined)\
**Post date:** [November 10, 2009, 8:17pm UTC](https://forum.kirupa.com/t/event-duration-what-is-more-effective-start-datetime-end-datetime-or-1-hr-long/299772/1 "2009-11-10T20:17:35Z")

</div>

I’m about to add Event Duration to the Calendar class.

There is two ways I believe I can approach this  
[LIST=1]  
[_]Add MySQL column for EventEndTime. Example: StartTime 2009-11-20 08:00:00, EndTime 2009-11-20 09:30:00  
[_]Add MySQL column for EventDuration. Example: EventTime 2009-11-20 08:00:00, EventDuration 01:30:00  
[/LIST]

Which one if your opinion is more effective?