Hi,
I use a mysql database to manage a list of posts. To do this is use a table with a column of the DATE type. My question is how do i sort on this date column ?
The date format should be dd-mm-yyyy, so i tried to use a "select datecol DATE_FORMAT(datcol, '%d-%m-%Y') as datecol ORDER BY datecol".
But that only sorts on the day-part, so how do i get a sorted list of dates from mysql ?
Thanks in advance
I use a mysql database to manage a list of posts. To do this is use a table with a column of the DATE type. My question is how do i sort on this date column ?
The date format should be dd-mm-yyyy, so i tried to use a "select datecol DATE_FORMAT(datcol, '%d-%m-%Y') as datecol ORDER BY datecol".
But that only sorts on the day-part, so how do i get a sorted list of dates from mysql ?
Thanks in advance