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
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.
You're welcome! I'm glad I could help clarify the options for the date format in database design. It's important to understand the differences and choose the appropriate format based on your specific needs and requirements.
In this case, option (b) DD/MM/YYYY represents the format where the date is written as day/month/year, like "13/01/1960" for January 13, 1960.
On the other hand, option (c) MM/DD/YYYY represents the format where the date is written as month/day/year, like "01/13/1960" for January 13, 1960.
Both formats are commonly used, but they differ in the order of the day and month. It's essential to choose the format that aligns with your region or the standard practice you want to follow in your database design.
I hope this helps you make an informed decision about the date format for your database. If you have any further questions or need clarification on anything else, feel free to ask!