| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oscar Estevez Lopez <oestevez(at)prisacom(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: extract and time zones |
| Date: | 2003-08-01 14:55:49 |
| Message-ID: | 8058.1059749749@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
Oscar Estevez Lopez <oestevez(at)prisacom(dot)com> writes:
> d : 1059744638
> d::timestamp : 1059737438
> ??
This is fixed as of PG 7.3.4 ...
2003-02-27 16:37 tgl
* src/backend/utils/adt/timestamp.c (REL7_3_STABLE): Change
EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone
is assumed to be in local time, not GMT. This improves consistency
with other operations, which all assume local timezone when it
matters. Per bug #897.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-01 15:19:25 | Re: extract and time zones |
| Previous Message | Tom Lane | 2003-08-01 14:41:22 | Re: casting timeofday() to timestamp boken under cygwin - Problem identified |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-08-01 14:56:02 | Re: How to do? |
| Previous Message | Ron Johnson | 2003-08-01 14:47:38 | Re: How to do? |