Re: output format for dates

am@fx.ro wrote:
> >
> >So, here comes my question:  is it possible to create a new
> >custom datestyle and set it as default ?
>
> Browsing the sources, i've found a function EncodeDateOnly() in
> src/backend/utils/adt which seems to be the function that generates
> strings representing dates.
>
> It seems easy to add a 'case' statement for a new datestyle.
> But, i guess that won't be enough.
>
> Where else should I add the new datestyle, so that i'll be able to
> use it with SET DATESTYLE ?

7.3 will have SET DATESTYLE:

    test=> set datestyle to 'iso,european';

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073