RE: Date Format

From: "Francis Solomon" <francis(at)stellison(dot)co(dot)uk>
To: "Daniel Hentges" <danielh(at)fockink(dot)ind(dot)br>, <pgsql-sql(at)postgresql(dot)org>
Subject: RE: Date Format
Date: 2000-12-13 13:45:30
Message-ID: NEBBIFFPELJMCJAODNPKEEOECDAA.francis@stellison.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • Date Format at 2000-12-13 10:51:28 from Daniel Hentges

Browse pgsql-sql by date

  From Date Subject
Next Message Borek Lupoměský 2000-12-13 13:59:32 Re: SQL parse error
Previous Message Mateusz Mazur 2000-12-13 11:45:55 Great thanks (JDBC). Another probem.