Options in specifying date format in Postgresql

Classic Servoy
1

Hi All

What are my options in specifying the date format in postgresql? I would prefer to set it permanently to the format used here (dd.mm.yyyy) in the db. Is there some sort of the Sybase set option date_order=‘dmy’ to set? Is it settable in the DB Server connection?

Thanks a lot for the help, Robert

2

Hi Robert,

I believe this is settable with the DateStyle variable. You can do this per database or you can set it in the postgresql.conf for the whole database server.
See http://www.postgresql.org/docs/8.2/stat … -DATESTYLE
PgAdmin3 can set this via the properties dialog (variables tab) of the database.

Hope this helps.