Thread: Change date format only for one DB

Change date format only for one DB

From

Miso Hlavac

Date:

12 December 2003, 15:57:46

hello,

I need to change date format from mm.dd.yyyy to dd.mm.yyyy
But only for one database. In other databases I need mm.dd.yyyy

is it possible set this format permanently???

thanx... miso

Re: Change date format only for one DB

From

Peter Eisentraut

Date:

12 December 2003, 16:20:30

Miso Hlavac wrote:
> I need to change date format from mm.dd.yyyy to dd.mm.yyyy
> But only for one database. In other databases I need mm.dd.yyyy

ALTER DATABASE xyz SET datestyle = ...