# Mysql DATE\_FORMAT

**URL:** https://forum.kirupa.com/t/mysql-date-format/266585
**Category:** Uncategorized
**Created:** [July 22, 2008, 12:49pm UTC](https://forum.kirupa.com/t/mysql-date-format/266585 "2008-07-22T12:49:12Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![gurechan](https://avatars.discourse-cdn.com/v4/letter/g/3be4f8/32.png) [@gurechan](https://forum.kirupa.com/u/gurechan)
#### Post date: [July 22, 2008, 12:49pm UTC](https://forum.kirupa.com/t/mysql-date-format/266585/1 "2008-07-22T12:49:12Z")

</div>

I have a table in mysql and one of the fields contains dates formatted ‘DD-MM-YYYY’.

I’ve been trying to order the results by the date field using:

SELECT \* FROM table ORDER BY DATE\_FORMAT(date, ‘%d-%m-%Y’) ASC

But this doesn’t order the results correctly. I’ve googled it a bit and I think I’ve got this correct.

Can anyone help, and let me know the correct way to do this.  
Thanks