Re: [WebDNA] Storing time in 24hr format
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 113052
interpreted = N
texte = 640 Maybe you ought to store times in WebDNA's default format. Then you can deal with it more easily later, for example if you want to change its web page display. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 10/07/2016 02:40 PM, dale wrote: > Hi all, > > I am going to be storing shirt start and shift end times in a db. > For now it is simply showing when the technicians are scheduled to > start and end their shift as well as when their lunch time starts. > > I'm not looking for code, only your thoughts on the smartest/most > flexible way to save the time. > > For doing any calculations I may need or want to do later, would > you recommend storing the time as: > > 6:00 > 06:00 > 0600 > > > I believe the later is the correct representation of 24 hour time. > And probably would be easier to do any math on the numbers. > > > For a further revision, I have been asked to look into eventually > using this site as a time clock to replace the system we are > currently using. These punch-in times and dates will be stored in > another database. The majority of the techs start work about 6:00 > pm and work until 3:00am. > > The above data will also include location information from their > mobile devices (they all work on various lots, so location > information is important). > > Thank you for your thoughts. > > Dale > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
640 Maybe you ought to store times in WebDNA's default format. Then you can deal with it more easily later, for example if you want to change its web page display. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 10/07/2016 02:40 PM, dale wrote: > Hi all, > > I am going to be storing shirt start and shift end times in a db. > For now it is simply showing when the technicians are scheduled to > start and end their shift as well as when their lunch time starts. > > I'm not looking for code, only your thoughts on the smartest/most > flexible way to save the time. > > For doing any calculations I may need or want to do later, would > you recommend storing the time as: > > 6:00 > 06:00 > 0600 > > > I believe the later is the correct representation of 24 hour time. > And probably would be easier to do any math on the numbers. > > > For a further revision, I have been asked to look into eventually > using this site as a time clock to replace the system we are > currently using. These punch-in times and dates will be stored in > another database. The majority of the techs start work about 6:00 > pm and work until 3:00am. > > The above data will also include location information from their > mobile devices (they all work on various lots, so location > information is important). > > Thank you for your thoughts. > > Dale > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us .
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Add to Cart & List of Products (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Case sensitivity and [showif] (1999)
Laying an egg. (1998)
expired beta (1997)
[searchstring] (1998)
Force a search at the default.tmpl page? (1997)
RE: [WebDNA] Max files size (2011)
WebCat and image maps (1997)
PhotoMill -> PhotoMaster (1997)
Two stores, one server (1998)
system crashes, event log (1997)
Smart caching problems with 2.1b3? (1997)
Email truncation test (1998)
Re:[ShowIf] and empty fields (1997)
Hiding HTML and page breaks (1997)
Help formatting search results w/ table (1997)
Emailer problem....still (1997)
fieldType=num (1997)
[WebDNA] Nginx (2010)