Re: Bug in function to_char() !! - Mailing list pgsql-general

From Tom Lane
Subject Re: Bug in function to_char() !!
Date
Msg-id 26809.1089036575@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in function to_char() !!  ("Najib Abi Fadel" <nabifadel@usj.edu.lb>)
List pgsql-general
"Najib Abi Fadel" <nabifadel@usj.edu.lb> writes:
> I tried to change the timezone (using timeconfig)

You didn't answer the question though: what timezone are you using?

If "SHOW timezone" produces something specific, that is the answer.
If it says "unknown" then what you will need to do is work out
which of the files under /usr/share/zoneinfo is an exact match
for /etc/localtime.

Also, was your Postgres built with --enable-integer-datetimes by
any chance?  (Look at the output of pg_config --configure if you
are not sure.)

            regards, tom lane

pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: Formatting Function..
Next
From: Stephen Liu
Date:
Subject: Re: How to add an userA to login postgresadmin