|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 7th, 2003, 11:55 AM
|
||||
|
||||
|
24 hour time
Does it make more sense to set 12 AM to 24:00 or to 00:00? Which will cause less trouble for inserting and reading from a database?
__________________
if (!$broke) { dontFixIt(); }
|
|
#2
August 7th, 2003, 02:15 PM
|
||||
|
||||
|
To me, it seems more logical to set midnight to 00:00 because it is the switch from PM to AM, thus starting a new day. All digital wrist-watches and clocks that I have ever seen also go from 23:59 to 00:00.
As far as more efficiency in databases, I really don't know.
|
|
#3
August 7th, 2003, 09:02 PM
|
||||
|
||||
|
Hmm. It seems that the database will accept 24:00:00, but will not properly use comparison operaters in the SQL queries (eg.: "SELECT * FROM TableName WHERE Time < '24:00:00'" will not work)
I've seem to come up with a bit of a work around though. Thanks for the suggestion 
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Software Design > 24 hour time |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
