El Fri, 01 Aug 2003 10:55:49 -0400 Tom Lane <[EMAIL PROTECTED]> escribio:
thanks :) > Oscar Estevez Lopez <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- ________________________________________________________ One ping to rule them all, one ping to find them, one ping to bring them all and in the darkness bind them. (Lord of the windows) ============================================================================ This e-mail message and any attached files are intended SOLELY for the addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY PRIVILEGED information and may not necessarily represent the opinion of this company. If you receive this message in ERROR, please immediately notify the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose, distribute, print or copy all or part of the contained information. Thank you. ============================================================================ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]