Hi folks!
There are a buch of varibles like DateStyle. I am interested to set
them
all in script shell.
I've tried in postgresql.conf, but I could not.
I've tried in shell environment, but it did not work.
So, how can I do that?
..
Hello Alessandro,
The manual I have says the following about Date/Time Styles:
- 4 styles (ISO-8601, SQL, Postgres, German)
The one which resembles your layout is German.
I looked it up in Bruce Momjians book.
Best regards,
Roelof
Alessandro Rossi schreef:
>
> I have the defaul installation o
Alessandro Rossi wrote:
> I have the defaul installation of postgres 7.0.3 and on another machine
> 7.1.2 on redhat 7.1
>
> I cannont get the date in correct form:
.
> Is this a bug ?
>
> I think i should get dd-mm-yyy date format and not -mm-dd
>
> Is postgres using ISO date format as
I have the defaul installation of postgres 7.0.3 and on another machine
7.1.2 on redhat 7.1
I cannont get the date in correct form:
dbme=# select data_ar from equipment limit 5;
data_ar
2001-11-05
2001-05-17
2001-05-28
2001-05-28
2001-05-22
(5 rows)
then:
dbme=# set dat
Hallo,
i have postgres 7.1 in Radhat 6.5
the Datestype default is ISO format
where is change default Datestyle to Postgres format ??
i used Set Datestyle to postgres in plsql
test#>select now()
now
2001-05-21 09:55:36+07
test#>set datestyle to postgres;
S
