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

> 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)

hth

                         - Thomas