Re: PGDATESTYLE

Поиск
Список
Период
Сортировка
Искать

Re: PGDATESTYLE

От:
"Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
Дата:
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.,  
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

PGDATESTYLE

От:
gme@ufba.br
Дата:
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?

Thanks in advance,
Gabriela.
FAQ