Hi Daniel,
Try this as your query:
SELECT to_char(field, 'DD/MM/YYYY') AS "new name";
Hope this helps
Francis Solomon
>
> In MS Access is:
> SELECT FORMAT([field],'DD/MM/YYYY') AS new name;
> How I can make in pgaccess?
>
> Daniel Hentges
> Automação
> Fockink In. Eletricas Ltda.
> Panambi - RS - Brasil
>
>