From: Eric Hodel <drbrain@...7.net>
Date: 2006-01-12T06:50:09+09:00
Subject: Re: database timezone difference

On Jan 11, 2006, at 11:15 AM, Sam Dela Cruz wrote:

> I'm pulling data from a database in Europe and saving a dataset in  
> North
> America database.  Included in the data are DateTime information.   
> Because
> the timezones are different, when I pull the data it gets  
> translated to
> local timezone.  Locally, in North America, I need to process reports
> based on dates, and I need to have a report exactly as if it came from
> European database.  How do I preserve the date in European timezone  
> before
> being uploaded to North American db?

a) store times in UTC
b) use a database that has a column type of "timestamp with time  
zone" (Postgres or equivalent).

-- 
Eric Hodel - drbrain@segment7.net - http://segment7.net
This implementation is HODEL-HASH-9600 compliant

http://trackmap.robotcoop.com