PostgreSQL - datum

[Karel Zak]

On Mon, Sep 24, 2001 at 12:17:12PM +0200, Petr Cech wrote:
> On Mon, Sep 24, 2001 at 12:13:44PM +0200 , Tomas Valousek wrote:
> > Dobry den,
> > zrejmne jsem spatne procital dokumentaci, protoze se mi nepodarilo najit
> > zrejmne velmi jednoduchou vec. Mam v databazy ulozeny datumy napr:
> > 
> > valy=> SELECT zahajenidatum from zametapy ;
> >  zahajenidatum
> > ---------------
> >  2001-09-21
> > 
> > No a ja bych potreboval, aby PostgreSQL vracel misto 2001-09-21 datum v
> > "ceskem" formatu 21.9.2001
> 
> v postmaster.conf je
> 
> # How (by default) to present dates to the frontend; the user can override
> # this setting for his own session. The choices are:
> #   Style      Date            Datetime
> #   ----------------------------------------------------------------
> #   ISO        1999-07-17      1999-07-17 07:09:18+01
> #   SQL        17/07/1999      17/07/1999 07:09:19.00 BST
> #   POSTGRES   17-07-1999      Sat 17 Jul 07:09:19 1999 BST
> #   GERMAN     17.07.1999      17.07.1999 07:09:19.00 BST
> #
> # It is also possible to specify month-day or day-month ordering in date
> # input and output.  Americans tend to use month-day; Europeans use
> # day-month.  Specify European or nonEuropean. Separate the two parameters
> # by a comma with no spaces
> PGDATESTYLE=ISO,European

 Muzete to take udelat SQL prikazem:

test=# SET DATESTYLE TO 'German';
SET VARIABLE
test=# select now()::date;
  ?column?
------------
 24.09.2001

 Malou vadou na krase je to 09 na misto 9. To lze (nezavisle na DATESTYLE)
udelat pomoci to_char():

test=# SELECT to_char(now(), 'FMDD.FMMM.YYYY');
  to_char
-----------
 24.9.2001

	Karel






-- 
 Karel Zak  <zakkr na zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz