| 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: | Whole Thread | Raw Message | 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^~§
| 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? |