Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> wrote: > Are you sure you want this without time zone? In my experience, > almost every time people think they want "without time zone" they > actually don't. +1 Basically, if you want to capture a moment in time, such as when some event happened or some measurement was taken, you want timestamp WITH time zone. If you want to know what was (or will be) showing on a clock in some particular time zone at a moment in time, you want timestamp WITHOUT time zone. The names tend to mislead one on the semantics of these types. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
