Posted by manny on .
I cannot find the correct answer in my text book it's unclear. I know it seems like a simple question, but I want to make sure I get it right. In Database Design:
The date format is
d. All of the above
Thanks for your help
I can't imagine what (a) would look like. (Do you know of a month with three digits??) So (a) and (d) are out.
(b) is correct if you want the date to read like this: 13/01/1960 (13 January 1960)
(c) is correct if you want the date to read like this: 01/13/1960 (January 13, 1960)
What will you choose?
It would be either b or c
In the US it is Month/Day/Year while in the rest of the world it is Day/Month/Year, in logical increasing units of time.
thanks for the help!
Thanks, Reiny, for reminding us that the U.S. doesn't use logic for dates (and other things?) :-)
We tried to get the metric system installed as the norm -- but I think that's a lost cause now.