Change date format only for one DB

Started by Michal Hlavacalmost 23 years ago2 messagesgeneral
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net
In reply to: Michal Hlavac (#2)
Re: Change date format only for one DB

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 = ...

#2Michal Hlavac
hlavki@medium13.sk

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