PostgreSQL - datum

[Petr Cech]

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

				Petr Cech
-- 
Debian GNU/Linux maintainer - www.debian.{org,cz}
           cech na atrey.karlin.mff.cuni.cz

* Joy notes some people think "Unix" is a misspelling of "Unics" which is a misspelling of "Emacs" :)