8 messages in com.mysql.lists.win32Re: MYSQL Date Format| From | Sent On | Attachments |
|---|---|---|
| Kamran Yahya | 19 Mar 2003 00:42 | |
| Jools Chesters | 19 Mar 2003 01:57 | |
| Kamran Yahya | 19 Mar 2003 02:32 | |
| Jools Chesters | 19 Mar 2003 02:55 | |
| PeterWR | 19 Mar 2003 03:00 | |
| Public Folder: MySQL | 19 Mar 2003 07:47 | |
| Public Folder: MySQL | 19 Mar 2003 11:54 | |
| PeterWR | 19 Mar 2003 12:50 |
| Subject: | Re: MYSQL Date Format |
|---|---|
| From: | PeterWR (pw...@post4.tele.dk) |
| Date: | 03/19/2003 12:50:34 PM |
| List: | com.mysql.lists.win32 |
Specially when having to sort, YYYYMMDD HHMMSS right away gives the correct sequence for sorting ascending or descending
Best regards Peter
----- Original Message ----- From: "Public Folder: MySQL" <ml.m...@in-genius.com> To: <win...@lists.mysql.com> Sent: Wednesday, March 19, 2003 8:55 PM Subject: RE: MYSQL Date Format
-----Original Message----- From: Warren S. Wyght [mailto:war...@wyght.com] Posted At: Wednesday, March 19, 2003 12:51 PM Posted To: MySQL Conversation: MYSQL Date Format Subject: Re: MYSQL Date Format
Why is DDMMYYYY more logical?
Because it's starting with the smallest granular measurement (days) and moving sequentially to the largest (years), just like YYYYMMDD starts with the largest (years) and moves to the smallest (days.)
DDMMYYYY = Small-medium-large YYYYMMDD = Large-medium-small
MMDDYYYY = Medium-Small-Large
The other response about sorting using YYYYMMDD makes way too much sense too.
-Kevin
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.