Re: sort by formatted date

[Peter Brawley]

Hmm, Union hides the column name, bummer, seems you have to do it this way ...

SELECT DATE_FORMAT(fecha, "%d-%b") as fdate, proveedor, importe
from (
select fecha, proveedor, importe
from db.tb
union
select fecha, proveedor, importe
from db2.tb
) x
order by x.fecha;

or form an ordering arg using substrings of fdate.