Re: partitiong on timestamp with local timezone data type
From: Stéphane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 23 May 2013 20:03:21 +0200
Message-ID: <519E59E9.1050002_at_roughsea.com>
I may have missed something, but if you know the timezone of each record, why don't you insert it as UTC ? (which means that then you don't need to *store* the timezone)
You can always adjust time when you retrieve data if you want to see it displayed in the server's local time. And it's probably easier to adjust that way if data is queried across the web by users in different timezones (retrieve the TZ offset of the user in Javascript in the browser, send it to the server, et voilà).
Date: Thu, 23 May 2013 20:03:21 +0200
Message-ID: <519E59E9.1050002_at_roughsea.com>
I may have missed something, but if you know the timezone of each record, why don't you insert it as UTC ? (which means that then you don't need to *store* the timezone)
You can always adjust time when you retrieve data if you want to see it displayed in the server's local time. And it's probably easier to adjust that way if data is queried across the web by users in different timezones (retrieve the TZ offset of the user in Javascript in the browser, send it to the server, et voilà).
-- Stephane Faroult RoughSea Ltd <http://www.roughsea.com> Konagora <http://www.konagora.com> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd> On 05/23/2013 07:45 PM, Dba DBA wrote:Received on Thu May 23 2013 - 20:03:21 CEST
> Oracle 11.2.0.3
> Production OS: Solaris (don't know the version)
> We insert date data that comes in a variety of timezones. We can tell what
> timezone each record is in. We need to normalize this date field to the
> timezone of our DB. We partition on this field.
> Timestamp with Local Timezone appears to meet this requirement and
> normalize it for me as long as I state the local timezone when I insert and
> set the dbtimezone parameter.
>
-- http://www.freelists.org/webpage/oracle-l