MySQL Forums
Forum List  »  Newbie

Re: sort by formatted date
Posted by: Miguel Rodriguez
Date: February 11, 2022 10:19AM

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'

Options: ReplyQuote


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.