Re: [WebDNA] Storing time in 24hr format
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 113050
interpreted = N
texte = 638 You want seconds since epoch. Sincerely, Donovan On Oct 7, 2016, at 2:40 PM, dale
wrote: > Hi all, >=20 > 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. >=20 > I'm not looking for code, only your thoughts on the smartest/most = flexible way to save the time. >=20 > For doing any calculations I may need or want to do later, would you = recommend storing the time as: >=20 > 6:00 > 06:00 > 0600 >=20 >=20 > I believe the later is the correct representation of 24 hour time. And = probably would be easier to do any math on the numbers.=20 >=20 >=20 > 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. >=20 > The above data will also include location information from their = mobile devices (they all work on various lots, so location information = is important).=20 >=20 > Thank you for your thoughts. >=20 > 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:
638 You want seconds since epoch. Sincerely, Donovan On Oct 7, 2016, at 2:40 PM, dale wrote: > Hi all, >=20 > 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. >=20 > I'm not looking for code, only your thoughts on the smartest/most = flexible way to save the time. >=20 > For doing any calculations I may need or want to do later, would you = recommend storing the time as: >=20 > 6:00 > 06:00 > 0600 >=20 >=20 > I believe the later is the correct representation of 24 hour time. And = probably would be easier to do any math on the numbers.=20 >=20 >=20 > 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. >=20 > The above data will also include location information from their = mobile devices (they all work on various lots, so location information = is important).=20 >=20 > Thank you for your thoughts. >=20 > 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 .
Donovan Brooke
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:
refreshing IE with posted .tmpl (1997)
Checkboxes (1997)
!!!!!!!!!!String Search!!!!!!!!!!!!!!!!!! (2001)
[WebDNA] Height, width of images (2013)
WebCat on Intel Core 2 macs anyone? (2007)
Toronto area? (1999)
Is this possible in simple search? question? (1998)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
Bug Report, maybe (1997)
Execute Applescript (1997)
[taxRate] [TaxTotal] ? (1997)
affiliate marketing program (1998)
Frames and WebCat (1997)
Re:Finding max value for a field (1997)
mail test (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Next (1997)
[cart] (1998)
Running _every_ page through WebCat-error.html (1997)
Emailer help....! (1997)