Hi All.
I have a datetime column in my model.
If I do an .order_by I get year-month-day
but how do I do an order_by to get month-day-year?
or even a day-month-year
Thanks,
Frans.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to
you'd need to use SQL functions that break the datetime into its component
parts, and order by them.
such as:
order_by(func.datepart(MONTH, my_date_col), func.datepart(DAY,
my_date_col), func.datepart(YEAR, my_date_col))
datepart routines vary by database backend with very little cross