Обсуждение: Date Format

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

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