Re: sort by formatted date
Thanks Peter, but with this query
SELECT DATE_FORMAT(fecha, "%d-%b") as fdate, proveedor, importe from db.tb1
UNION
SELECT DATE_FORMAT(fecha, "%d-%b") as fdate, proveedor, importe from db2.tb1
order by fecha;
I get this error...
Error Code: 1054. Unknown column 'fecha' in 'order clause'
Subject
Written By
Posted
February 11, 2022 02:16AM
February 11, 2022 09:45AM
Re: sort by formatted date
February 11, 2022 10:19AM
February 11, 2022 10:21AM
February 11, 2022 10:59AM
February 11, 2022 02:20PM
February 15, 2022 10:06AM
February 17, 2022 12:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.