homepage Welcome to WebmasterWorld Guest from 54.197.94.241
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Question about date & time fields for work order start and duration.
nelsonm




msg:4508622
 10:14 pm on Oct 16, 2012 (gmt 0)

hi all,

my dispatch board shows work order objects of varying start times and duration. The duration can span across hours or days. The duration is also restricted to an 8 hour work day. So, the duration for a work order that spans 1.5 days is only 12 hours.

My question is...

Is it better to define the start and duration as two datetime fields or as one start datetime field and a duration time field?

Examples:
StartDateTime[12-10-05 09:00:00], EndDateTime[12-10-06 13:00:00]
- or -
StartDateTime[12-10-05 09:00:00], Duration[12:00:00]

thanks.

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved