Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBDDRBM80254
	for <pgsql-sql@postgresql.org>; Wed, 13 Dec 2000 08:27:11 -0500 (EST)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from fockink.ind.br ([200.182.181.177])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBDAmrM68411
	for <pgsql-sql@postgresql.org>; Wed, 13 Dec 2000 05:49:29 -0500 (EST)
	(envelope-from danielh@fockink.ind.br)
Received: from FOCKINK-Message_Server by fockink.ind.br
	with Novell_GroupWise; Wed, 13 Dec 2000 08:52:06 -0200
Message-Id: <sa3738b6.035@fockink.ind.br>
X-Mailer: Novell GroupWise 5.2
Date: Wed, 13 Dec 2000 08:51:28 -0200
From: "Daniel Hentges" <danielh@fockink.ind.br>
To: pgsql-sql@postgresql.org
Subject: Date Format
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id
	eBDAnVM68412
X-Archive-Number: 200012/101
X-Sequence-Number: 434

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