RE: [SQL] Date Format

[Francis Solomon]

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
>
>