> >Start the server with the desired TZ set.
>
> That's all fine and good, but difficult switch back and forth every 10
> minutes while that query runs for local data, then for the remote data.
=Agreed you must stick with either one or the other, right?
=Wrong! To fix the problem of different of
Jeremy Wilson wrote:
> At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
> >Start the server with the desired TZ set.
>
> That's all fine and good, but difficult switch back and forth every 10
> minutes while that query runs for local data, then for the remote data.
The way I deal with it (and I d
At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
>Start the server with the desired TZ set.
That's all fine and good, but difficult switch back and forth every 10
minutes while that query runs for local data, then for the remote data.
-
Start the server with the desired TZ set.
Jeremy Wilson wrote:
> I have a data collection script which rolls raw data into a formatted
> table, based on year/month/day. I've been requested to roll up this raw
> data based on a different timezone - 3 hours behind - to better coincide
> with rep
I have a data collection script which rolls raw data into a formatted
table, based on year/month/day. I've been requested to roll up this raw
data based on a different timezone - 3 hours behind - to better coincide
with reports from a company in that timezone.
This is the rollup SQL query we cur
