# ORDER BY date

**URL:** <https://forum.kirupa.com/t/order-by-date/191677>\
**Category:** programming\
**Created:** [June 22, 2006, 7:24am UTC](https://forum.kirupa.com/t/order-by-date/191677 "2006-06-22T07:24:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pucca](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@pucca](https://forum.kirupa.com/u/pucca)\
**Post date:** [June 22, 2006, 7:24am UTC](https://forum.kirupa.com/t/order-by-date/191677/1 "2006-06-22T07:24:27Z")

</div>

hi there, I’ve got a table, with a date field. It’s not a timestamp, it’s a varchar where you enter your own date (ex. 19 January)… I would like to order that column, but when I put in “ORDER BY date”… it orders my column via the “days”… (ex. 19 January, 9 March, 20 June will be ordered : 9 March, 19 January, 20 June)

Is there ANY way I can order them by the actual DATE?

PLEASE help!!! 🙂  
Thanks!