PGDATESTYLE

On Mon, Apr 24, 2000 at 02:30:01PM -0300, gme@ufba.br wrote:

Hi all,

I'd like to know how I can show a date field in the
format MM/DD/YYYY. Seting the PGDATESTYLE=European,SQL
the date field are shown DD/MM/YYYY. What value should I
set the PGDATESTYLE to show the dates as I want?

Try US,SQL or NonEuropean,SQL:

reedstrm=> set datestyle='NonEuropean,SQL';
SET VARIABLE
reedstrm=> show datestyle;
NOTICE: DateStyle is SQL with US (NonEuropean) conventions
SHOW VARIABLE
reedstrm=> select date(now());
date
----------
04/24/2000
(1 row)

reedstrm=> set datestyle='European,SQL';
SET VARIABLE
reedstrm=> select date(now());
date
----------
24/04/2000
(1 row)

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005