pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDataStyle
3+ messages / 3 participants
[nested] [flat]
* DataStyle
@ 1999-06-10 09:57 Remigiusz Sokolowski <rems@gdansk.sprint.pl>
0 siblings, 2 replies; 3+ messages in thread
From: Remigiusz Sokolowski @ 1999-06-10 09:57 UTC (permalink / raw)
To: pgsql-sql
Hi!
I did something like that:
torell=> set DataStyle to 'ISO';
and get something like this:
NOTICE: Unrecognized variable datastyle
SET VARIABLE
I try also with 'European' DataStyle - I remeber, that sometime ago this
command functions OK, and we've made no changes in configuration of
database.
So my question is:
If there is a way to set DataStyle manually?
And if it is possible to set it default 'European' to all users?
As I saw it seems, that every user has its own settings of this.
TIA
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] DataStyle
@ 1999-06-10 12:13 José Soares <jose@sferacarta.com>
parent: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1 sibling, 0 replies; 3+ messages in thread
From: José Soares @ 1999-06-10 12:13 UTC (permalink / raw)
To: Remigiusz Sokolowski <rems@gdansk.sprint.pl>; +Cc: pgsql-sql
Remigiusz Sokolowski ha scritto:
> Hi!
> I did something like that:
> torell=> set DataStyle to 'ISO';
>
> and get something like this:
> NOTICE: Unrecognized variable datastyle
> SET VARIABLE
>
> I try also with 'European' DataStyle - I remeber, that sometime ago this
> command functions OK, and we've made no changes in configuration of
> database.
>
hygea=> set DateStyle to 'ISO';
SET VARIABLE
>
> So my question is:
> If there is a way to set DataStyle manually?
> And if it is possible to set it default 'European' to all users?
> As I saw it seems, that every user has its own settings of this.
> TIA
> Rem
>
You can do this job in three different ways:
1. Setting PGDATESTYLE environment variable for everey client
as:
export PGDATESTYLE='sql,european' # this format is:
dd/mm/yyyy
2. Running postmaster using -oe parameter to set format
date to 'European' convention.
3. Changing the following variables:
bool EuroDates = true / false
int DateStyle =
USE_ISO_DATES
USE_POSTGRES_DATES
USE_ISO_DATES
USE_SQL_DATES
USE_GERMAN_DATES
on ~/src/backend/utils/init/globals.c file before PostgreSQL
installation).
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] DataStyle
@ 1999-06-10 14:14 Emils Klotins <emils@mail.usis.bkc.lv>
parent: Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Emils Klotins @ 1999-06-10 14:14 UTC (permalink / raw)
To: Remigiusz Sokolowski <rems@gdansk.sprint.pl>; +Cc: pgsql-sql
[10 Jun 99,, 11:57] Remigiusz Sokolowski wrote:
> Hi!
> I did something like that:
> torell=> set DataStyle to 'ISO';
>
> and get something like this:
> NOTICE: Unrecognized variable datastyle
> SET VARIABLE
I believe it should be DatEstyle not DatAstyle.
For dates.
Emils Klotins e-mail: emils@mail.usis.bkc.lv
Systems Manager URL: http://www.usis.bkc.lv/
USIS Riga 7 Smilsu Str., Riga LV1050, LATVIA
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-06-10 14:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-10 09:57 DataStyle Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1999-06-10 12:13 ` José Soares <jose@sferacarta.com>
1999-06-10 14:14 ` Emils Klotins <emils@mail.usis.bkc.lv>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox