# \[SQL\] ORDER BY month, but jan feb ect

**URL:** <https://forum.kirupa.com/t/sql-order-by-month-but-jan-feb-ect/236007>\
**Category:** Uncategorized\
**Created:** [August 16, 2007, 1:38pm UTC](https://forum.kirupa.com/t/sql-order-by-month-but-jan-feb-ect/236007 "2007-08-16T13:38:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Templarian](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/templarian/32/7152_2.png) [@Templarian](https://forum.kirupa.com/u/Templarian)\
**Post date:** [August 16, 2007, 1:38pm UTC](https://forum.kirupa.com/t/sql-order-by-month-but-jan-feb-ect/236007/1 "2007-08-16T13:38:43Z")

</div>

I have a database here at work and they need the order by changed to the date, but the month is in varchar not integer like year and day.

January  
February  
ect…

and not, 0,1 its harder. How exactly would I be able to do this?

I’m using postgreSQL btw.

Thanks.