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:

Question

The date format is

a. DD-MMM-YYYY
b. DD/MM/YYYY
c. MM/DD/YYYY
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.