Re: [SQL] Assigning a timestamp without timezone to a timestamp with timezone

2006-10-03 Thread Andrew Sullivan
On Mon, Oct 02, 2006 at 08:15:56PM -0700, chrisj wrote: > Two tables both the have open and close columns that are timestamp or > timestamp with time zone. I think the best answer is to convert the one table to timestamptz, and always enter explicitly the time zone with it (since you're going to k

[SQL] Assigning a timestamp without timezone to a timestamp with timezone

2006-10-02 Thread chrisj
Hi Does any one have any ideas for the following problem? Two tables both the have open and close columns that are timestamp or timestamp with time zone. One row in first table represents the corporate office default open and close times for all stores relative to the store?s own time zone for a