On Wed, 23 May 2007, [EMAIL PROTECTED] wrote:
Would I be right in thinking that, in general, a column to hold timestamp values is best created with type 'TIMESTAMP WITH TIME ZONE' and not 'TIMESTAMP' nor 'TIMESTAMP WITHOUT TIME ZONE'?
If the application's users are in different time zones, or accurate time intervals are important, then time zones should be part of the stored data. If this is not an issue, and will not be an issue, it does not matter. However, using 'WITH TIME ZONE' in the DDL means that if the situation changes you are covered. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
