I am going to be storing shirt = start and shift end times in a db. For now it is simply showing when the te= chnicians are scheduled to start and end their shift as well as when their = lunch time starts.
I'm not looking for code, o= nly 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 prob= ably would be easier to do any math on the numbers.=C2=A0
For a further revision, I have been asked to look in= to 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 d= atabase. 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 lo= cation information is important).=C2=A0
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 --001a113d5ece95a491053e4b96e0-- .
Associated Messages, from the most recent to the oldest:
637 --001a113d5ece95a491053e4b96e0 Content-Type: text/plain; charset=UTF-8 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 --001a113d5ece95a491053e4b96e0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 te= chnicians are scheduled to start and end their shift as well as when their = lunch time starts.