Re: converting to german date format - Mailing list pgsql-general

Am Samstag, 29. September 2001 09:52 schrieb Thomas Lockhart:
> > i have different databases with have columns of type 'date'.
> > my application converts the date format to german date format
> > like 09-28-2001 to 28.09.2001 and back again if the user enters a
> > german date format.
> > are there any solutions to do stuff like this inside the
> > database?
>
> Of course :)
>
> thomas=# set datestyle = 'german';
> SET VARIABLE
>
> thomas=# select date 'now';
>     date
> ------------
>  29.09.2001
> (1 row)

it's easier than i expected. Thanks a lot!

janning