select date_format(nome_campo, "%d.%m.%Y %T") as dataora from tabella