formato de fecha dmy solo para un usuario o una base de datos - RESUELTO

From: "Calabaza Calabaza" <calalinux(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: formato de fecha dmy solo para un usuario o una base de datos - RESUELTO
Date: 2007-05-21 14:29:02
Message-ID: 958993320705210729o4a412e48ib7e31641b37dc136@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Creo que he encontrado la solucion:

alter database tu_db SET DateStyle to 'sql, dmy'; -- Para cambiar solo
a esta bd.

documentacion:
PostgreSQL 8.0.3 Documentation 16.4. Run-time Configuration:
"....Furthermore, it is possible to assign a set of option settings to
a user or a database. Whenever a session is started, the default
settings for the user and database involved are loaded. The commands
ALTER USER and ALTER DATABASE, respectively, are used to configure
these settings. Per-database settings override anything received from
the postmaster command-line or the configuration file, and in turn are
overridden by per-user settings; both are overridden by per-session
options...."
Si tengo problemas les escribo de nuevo... gracias nuevamente...
--
§~^Calabaza^~§

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Gabriel Ferro 2007-05-21 15:28:11 Instalacion en LAN
Previous Message mario vargas careaga 2007-05-21 14:11:05 como puedo mostrar el resultado de dos select?