Posted by Bob A on October 19, 2009 at 12:23:00:
In Reply to: Re: Date data type - Grant,Jon, Steve,Bob A, Jim & Comet Woman posted by Grant Foraker on October 16, 2009 at 11:33:25:
Actually YYYY-MM-DD has been used as the standard in both Sweden and Japan for decades now.... and has been the standard from the International Standard #8601 from the International Organization for Standardization (ISO) (see: http://en.wikipedia.org/wiki/ISO_8601 )
apropos ISO 8601, includes a "week" format of YYYY-W##-D (where up to W53 In DB2/400 IBM uses the following: the "option 7" for Num2Date would be great.... "getting it in one slurp" would surely be useful, if only for sorting purposes. finally, I've never seen YYYYDDMM in use anywhere.... willing to bet at least $2.56 that nobody does.... Bob "A"
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.
*MDY which is MM/DD/YY *MDY0 which is MMDDYY
*DMY which is DD/MM/YY *DMY0 which is DDMMYY
*YMD which is YY/MM/DD *YMD0 which is YYMMDD
*JUL which is YY/JJJ *JUL0 which is YYJJJ
*USA which is MM/DD/YYYY *USA0 which is MMDDYYYY
*EUR which is DD.MM.YYYY *EUR0 which is DDMMYYYY
*JIS which is YYYY-MM-DD *JIS0 which is YYYYMMDD (Japanese Information Standard)
*ISO which is YYYY-MM-DD *JIS0 which is YYYYMMDD
note that the post Y2K dates (*USA, *EUR, *JIS, *ISO) have delimiters that indicate what the format is when you see the date... pre Y2K there were Editing Masks that would override the USA-centric "slash" ("oblique stroke" to the Eurocentric) I'm not sure how much COMET is used in Europe, but Canada surely uses dd.mm.yyyy