"TIMESTAMP and TIME may also be specified as being WITH TIME ZONE, in which case every value has associated with it a time zone displacement. In comparing values of a data type WITH TIME ZONE, the value of the time zone displacement is disregarded." Well what's the point then?
In the spec, timestamp comparison is defined roughly as: convert everything to local time, subtract to give an interval in terms of the smallest time unit present, and compare that against 0 to determine less/equal/greater
-
-
If you're thinking "but DST...?" then you have observed one of the reasons why
@PostgreSQL does not follow the spec in this area; the spec has no concept of DSTThanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.