MySQL Forums
Forum List  »  Italian

Aggiungo alias AS a DATE_FORMAT e mi da errore
Posted by: Tobia Scandolara
Date: June 08, 2020 11:45AM

Buonasera a tutti,
sto impazzendo con questo problema che non mi รจ mai capitato.

Se provo ad aggiungere un alias AS a un campo DATE_FORMAT in una query banale del tipo

SELECT *,DATE_FORMAT(campo_data,'%d-%m-%Y') AS valore FROM mia_tabella, la query si blocca.

Se invece levo l'alias, funziona.

Mi potete aiutare per favore?

Tobia

Options: ReplyQuote


Subject
Views
Written By
Posted
Aggiungo alias AS a DATE_FORMAT e mi da errore
490
June 08, 2020 11:45AM


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.