> 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