Received: from smtp.stellison.co.uk ([212.56.66.225])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBDDiPM86015
	for <pgsql-sql@postgresql.org>; Wed, 13 Dec 2000 08:44:26 -0500 (EST)
	(envelope-from francis@stellison.co.uk)
Received: (qmail 11206 invoked from network); 13 Dec 2000 13:45:05 -0000
Received: from unknown (HELO neo) (unknown)
	by unknown with SMTP; 13 Dec 2000 13:45:05 -0000
From: "Francis Solomon" <francis@stellison.co.uk>
To: "Daniel Hentges" <danielh@fockink.ind.br>, <pgsql-sql@postgresql.org>
Subject: RE: Date Format
Date: Wed, 13 Dec 2000 13:45:30 -0000
Message-ID: <NEBBIFFPELJMCJAODNPKEEOECDAA.francis@stellison.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
In-reply-to: <sa3738b6.035@fockink.ind.br>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Importance: Normal
X-Archive-Number: 200012/102
X-Sequence-Number: 435

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