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