dbTalk Databases Forums  

Won't bring back Dates correctly..

comp.databases.mysql comp.databases.mysql


Discuss Won't bring back Dates correctly.. in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
aquanutz@gmail.com
 
Posts: n/a

Default Won't bring back Dates correctly.. - 09-25-2006 , 10:57 AM






My sql query will not seem to bring back dates in the correct order. It

will brin them back in a semi-order. Here is the query and what it
brings back. Any thoughts on how to get the dates to come back in
order, formatted the way I want? Thanks.
QUERY:

select num, DATE_FORMAT(startDate,'%b %e, %Y') as startDate,
DATE_FORMAT(endDate, '%b %e, %Y') as endDate, reason from
exceptionDates order by startDate DESC, endDate DESC;

RESULTS:

+-----+--------------+--------------+----------------------+
Quote:
num | startDate | endDate | reason |
+-----+--------------+--------------+----------------------+
2 | Sep 1, 2006 | Sep 4, 2006 | Labor Day |
3 | Oct 6, 2006 | Oct 10, 2006 | Fall Break |
5 | Nov 21, 2006 | Nov 26, 2006 | thanksgiving |
4 | Nov 10, 2006 | Nov 12, 2006 | veteran's day |
12 | Mar 5, 2007 | Mar 11, 2007 | Spring Break Week |
11 | Mar 2, 2007 | Mar 4, 2007 | Spring Break Weekend |
10 | Jan 12, 2007 | Jan 15, 2007 | MLK Weekend |
7 | Dec 30, 2006 | Jan 1, 2007 | new year's break |
6 | Dec 23, 2006 | Dec 29, 2006 | Christmas Break |
9 | Apr 14, 2007 | Apr 14, 2007 | Special Closing |
+-----+--------------+--------------+----------------------+



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.