| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb> |
| Cc: | "generalpost" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Bug in function to_char() !! |
| Date: | 2004-07-05 14:09:35 |
| Message-ID: | 26809.1089036575@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Liu | 2004-07-05 16:41:05 | Re: How to add an userA to login postgresadmin |
| Previous Message | Franco Bruno Borghesi | 2004-07-05 13:20:07 | Re: Formatting Function.. |