Forum Moderators: open
2007-08-01 10:30:00-0700
I'm on a 24 hour clock. All clocks in the house (that allow me to configure) are adjusted to 24 hour time.
I changed to ISO date and time format back in 2000 I believe. I've been using 24 hour time since I was a teenager in the service.
1300-2359 - Subtract 12 to get 12 hour time.
lol, I'll ask my 7 year old daughter what time it is and she'll tell me "it's 19:30 Dad". In the beginning when I was first teaching her, it was 19:30 O'Clock. :)
I just got her a clock for her room that has both 12 and 24 hour time. Makes it easy for her to memorize.
I really think the ISO standards should be used by all. It just eliminates any guesswork.
should be ascending or descending order
day - month - year
year - month - day
how does it make any sense to swap day with month, drives me nuts. You have to look at other dates in the same text/article/site if both numbers are smaller than 12.
I like text, no confusion
Wed Aug 1, 1:46 PM
Mittwoch, 01.08.2007 (always dd.mm.yyyy)
Uhrzeit: 19:56 or: kurz vor acht. (short before eight)
Here in Germany everybody is on a 24 hour clock. I think it makes life much easier. Especially when you are doing business internationally. At least you are less likely to call your business partner at 3 in the morning because you thought in their time zone it is already 3 p.m.
Any other arrangement will not sort logically in chronological order if cast to a long int or something else.
Store as some variety of DateTime in the products I work with, but that arrangement (like 200708011404) is perfect for all kinds of things that you might sort. I find it odd that people name files like Aug-1Invoice.xls when they could do 20070801Invoice.xls so their files will sort chronologically instead of alphabetically.
I also deal a lot with Japan, where it's YYYY-MM-DD (where YYYY can be either 2007 or Heisei 18). And in Thailand it's already 2550.
lol, I'll ask my 7 year old daughter what time it is and she'll tell me "it's 19:30 Dad". In the beginning when I was first teaching her, it was 19:30 O'Clock. :)
My youngest sis when she was about 3, when somebody asks her what time it was, she used to say "The long one is on 3 and the short one is on 9" That is for 15 past 9. One day the time was exactly at 12 and she came back quite surprised, "the long one is at 12 and the short is not there." :)
Yet you neglected the day before month convention? Why? ; )
We had Julian Dates [aa.usno.navy.mil]. It took me a while to come up with a system to memorize those. :)
Short Time: 06:30
Long Time: 06:30:00-0700
Short Date: 2007-08-02
Long Date: 2007 August 02, Thursday
ISO Date and Time: 2007-08-02 06:30:00-0700
Julian Date: 2454314.76806
Personally, I can never understand mm/dd/yyyy. I use yyy/mm/dd/time for filenames, timestamps etc. and then 3-Aug-2007 for letters.
So my date and time? Nothing.