Author: Fred Taylor
Posted: 2012-02-07 11:06:51 Link
Any body know of a way to intercept the returns from DATE(), DATETIME(),
TIME() etc. for different timezones WITHOUT changing the Windows setting
for timezone?
We've moved a bunch of applications to the cloud and now have users
accessing from multiple timezones, but the application wasn't built to
handle that. We can't just change the Windows timezone, as that would
confuse the users with their Outlook calendars, or any other time based
applications. There are 5 applications and they would have about 9,000
places each in the code would need to be changed if we have to change the
calls to DATE(), DATETIME(), etc. to use a different function. Most
definitely not looking forward to 45K changes to code!
Thanks for any insight in to this (huge) dilemma.
Fred
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksrSAfHLHbgaaHA6Htvh8UsD+MMP8xT6X_BuPtDfX2z8gQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2012-02-07 11:14:22 Link
On Tue, Feb 7, 2012 at 10:06 AM, Fred Taylor <fbtaylor@gmail.com> wrote:
> Any body know of a way to intercept the returns from DATE(), DATETIME(),
> TIME() etc. for different timezones WITHOUT changing the Windows setting
> for timezone?
>
> We've moved a bunch of applications to the cloud and now have users
> accessing from multiple timezones, but the application wasn't built to
> handle that. We can't just change the Windows timezone, as that would
> confuse the users with their Outlook calendars, or any other time based
> applications. There are 5 applications and they would have about 9,000
> places each in the code would need to be changed if we have to change the
> calls to DATE(), DATETIME(), etc. to use a different function. Most
> definitely not looking forward to 45K changes to code!
>
> Thanks for any insight in to this (huge) dilemma.
-------------------------------
<http://www.4guysfromrolla.com/articles/081507-1.aspx>
Universal time is actually the basis of all time and from there the
machine will adjust it to local. :) If you do a test to catch
getdate() say a million times and then use getUTCDate() it will be
faster with the second.
SELECT toUTC([MyDateColumn], [MyTimeZoneColumn]) FROM [MyTable]
here is a function to do it in vb or C#
<http://www.codeproject.com/Articles/31146/SQL-2005-Time-Zone-Conversion-Functions>
--
Stephen Russell
901.246-0159 cell
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMY+0fN0bg_oB_WrppeJ03Zy13FfsJiLT_f0gMwjuA51pCw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Paul Newton
Posted: 2012-02-07 11:16:09 Link
Fred
If you DO have to change the calls I would recommend that you take a look at GoFish available on Codeplex ... you would be able to globally change DateTime( to MyDateTime( etc and then try to achieve what you need in the custom functions MyDateTime(), MyDate(), and MyTime()
Paul
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Fred Taylor
Sent: 07 February 2012 16:07
To: profoxtech@leafe.com
Subject: Any way to alter the time returned by windows for DATETIME()?
Any body know of a way to intercept the returns from DATE(), DATETIME(),
TIME() etc. for different timezones WITHOUT changing the Windows setting for timezone?
We've moved a bunch of applications to the cloud and now have users accessing from multiple timezones, but the application wasn't built to handle that. We can't just change the Windows timezone, as that would confuse the users with their Outlook calendars, or any other time based applications. There are 5 applications and they would have about 9,000 places each in the code would need to be changed if we have to change the calls to DATE(), DATETIME(), etc. to use a different function. Most definitely not looking forward to 45K changes to code!
Thanks for any insight in to this (huge) dilemma.
Fred
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/96D5B71C2B277647A0ECF548F1EBF52706C2A32BAE@UKFAWEXMB2.infor.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Fred Taylor
Posted: 2012-02-07 11:45:00 Link
Thanks Paul. That may be the route that has to be taken. I'm just not
that comfortable with that massive a change.
Fred
On Tue, Feb 7, 2012 at 9:16 AM, Paul Newton <Paul.Newton@pegasus.co.uk>wrote:
> Fred
>
> If you DO have to change the calls I would recommend that you take a look
> at GoFish available on Codeplex ... you would be able to globally change
> DateTime( to MyDateTime( etc and then try to achieve what you need in the
> custom functions MyDateTime(), MyDate(), and MyTime()
>
> Paul
>
> -----Original Message-----
> From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]
> On Behalf Of Fred Taylor
> Sent: 07 February 2012 16:07
> To: profoxtech@leafe.com
> Subject: Any way to alter the time returned by windows for DATETIME()?
>
> Any body know of a way to intercept the returns from DATE(), DATETIME(),
> TIME() etc. for different timezones WITHOUT changing the Windows setting
> for timezone?
>
> We've moved a bunch of applications to the cloud and now have users
> accessing from multiple timezones, but the application wasn't built to
> handle that. We can't just change the Windows timezone, as that would
> confuse the users with their Outlook calendars, or any other time based
> applications. There are 5 applications and they would have about 9,000
> places each in the code would need to be changed if we have to change the
> calls to DATE(), DATETIME(), etc. to use a different function. Most
> definitely not looking forward to 45K changes to code!
>
> Thanks for any insight in to this (huge) dilemma.
>
> Fred
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBkso17E0VoWjb_rO4ogg5RqVq8cbjpkE0idYpGiAFE6iSSA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Tracy Pearson
Posted: 2012-02-07 11:49:09 Link
Fred Taylor wrote on 2012-02-07:
> Thanks Paul. That may be the route that has to be taken. I'm just not
> that comfortable with that massive a change.
>
> Fred
>
>> We've moved a bunch of applications to the cloud and now have users
>> accessing from multiple timezones, but the application wasn't built to
>> handle that.
Fred,
Are they writing to the data in the cloud directly, or is there a middle
point that can be changed to handle the incoming request and adjust the
date/time stamps?
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/000701cce5b8$69f6b1e0$3de415a0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Eurico Chagas Filho
Posted: 2012-02-07 12:11:48 Link
Fred
You can use a look up reference to make a global change. You could build routines
and make them change places w the build in ones.
I habe been using PEM Editor w success.
E.
>________________________________
> From: Fred Taylor <fbtaylor@gmail.com>
>To: ProFox Email List <profox@leafe.com>
>Sent: Tuesday, February 7, 2012 2:45 PM
>Subject: Re: Any way to alter the time returned by windows for DATETIME()?
>
>Thanks Paul. That may be the route that has to be taken. I'm just not
>that comfortable with that massive a change.
>
>Fred
>
>
>On Tue, Feb 7, 2012 at 9:16 AM, Paul Newton <Paul.Newton@pegasus.co.uk>wrote:
>
>> Fred
>>
>> If you DO have to change the calls I would recommend that you take a look
>> at GoFish available on Codeplex ... you would be able to globally change
>> DateTime( to MyDateTime( etc and then try to achieve what you need in the
>> custom functions MyDateTime(), MyDate(), and MyTime()
>>
>> Paul
>>
>> -----Original Message-----
>> From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]
>> On Behalf Of Fred Taylor
>> Sent: 07 February 2012 16:07
>> To: profoxtech@leafe.com
>> Subject: Any way to alter the time returned by windows for DATETIME()?
>>
>> Any body know of a way to intercept the returns from DATE(), DATETIME(),
>> TIME() etc. for different timezones WITHOUT changing the Windows setting
>> for timezone?
>>
>> We've moved a bunch of applications to the cloud and now have users
>> accessing from multiple timezones, but the application wasn't built to
>> handle that. We can't just change the Windows timezone, as that would
>> confuse the users with their Outlook calendars, or any other time based
>> applications. There are 5 applications and they would have about 9,000
>> places each in
the code would need to be changed if we have to change the
>> calls to DATE(), DATETIME(), etc. to use a different function. Most
>> definitely not looking forward to 45K changes to code!
>>
>> Thanks for any insight in to this (huge) dilemma.
>>
>> Fred
>>
>>
>> --- StripMime Report -- processed MIME parts --- multipart/alternative
>> text/plain (text body -- kept)
>> text/html
>> ---
>>
>[excessive quoting removed by server]
>
>_______________________________________________
>Post Messages to: ProFox@leafe.com
>Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
>OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
>Searchable Archive: http://leafe.com/archives/search/profox
>This message:
>** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
>
>
>
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1328634708.85375.YahooMailNeo@web160804.mail.bf1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Paul McNett
Posted: 2012-02-07 12:28:01 Link
On 2/7/12 8:06 AM, Fred Taylor wrote:
> if we have to change the
> calls to DATE(), DATETIME(), etc. to use a different function. Most
> definitely not looking forward to 45K changes to code!
Automated changes, not manual, right? There are tools for that.
Paul
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4F315F21.8030303@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Fred Taylor
Posted: 2012-02-07 13:20:32 Link
Absolutely.
Fred
On Tue, Feb 7, 2012 at 10:28 AM, Paul McNett <p@ulmcnett.com> wrote:
> On 2/7/12 8:06 AM, Fred Taylor wrote:
> > if we have to change the
> > calls to DATE(), DATETIME(), etc. to use a different function. Most
> > definitely not looking forward to 45K changes to code!
>
> Automated changes, not manual, right? There are tools for that.
>
> Paul
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksoh-uCnJXZJ=bVLuYNg1M38uAP3FmLpk-extMvdKK93vg@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Fred Taylor
Posted: 2012-02-07 13:34:53 Link
It's just plain old VFP updating tables. The problem is that a user from
EST zone stamps a record at say 11:00 AM local time. A user from PST
stamps a record at 10:00 AM local time (1:00 PM EST). The 10:00 AM time is
in the change queue as before the 11 AM entry, even though it occurred
later. This code wasn't written to handle updating from different
timezones, the old system ran on a terminal server that everyone logged
into that was EST, so all times were EST.
Now, everything is on the cloud, and the times are local to where the user
is at, hence the problem.
Fred
On Tue, Feb 7, 2012 at 9:49 AM, Tracy Pearson <tracy@powerchurch.com> wrote:
> Fred Taylor wrote on 2012-02-07:
> > Thanks Paul. That may be the route that has to be taken. I'm just not
> > that comfortable with that massive a change.
> >
> > Fred
> >
> >> We've moved a bunch of applications to the cloud and now have users
> >> accessing from multiple timezones, but the application wasn't built to
> >> handle that.
>
> Fred,
>
> Are they writing to the data in the cloud directly, or is there a middle
> point that can be changed to handle the incoming request and adjust the
> date/time stamps?
>
> Tracy Pearson
> PowerChurch Software
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksrx7=m4g=8UapHvXUa9BnGxc8DEOHsoHmrrdj3fEcJ3EQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Fred Taylor
Posted: 2012-02-07 13:36:35 Link
Thanks Eurico, that looks like what's got to be done a mass change. Code
is being written to handle an offset to the VFP local time to make
everything consistent again.
Fred
On Tue, Feb 7, 2012 at 10:11 AM, Eurico Chagas Filho <e28chagas@yahoo.com.br
> wrote:
> Fred
>
>
> You can use a look up reference to make a global change. You could build
> routines
> and make them change places w the build in ones.
> I habe been using PEM Editor w success.
>
>
> E.
>
>
>
> >________________________________
> > From: Fred Taylor <fbtaylor@gmail.com>
> >To: ProFox Email List <profox@leafe.com>
> >Sent: Tuesday, February 7, 2012 2:45 PM
> >Subject: Re: Any way to alter the time returned by windows for DATETIME()?
> >
> >Thanks Paul. That may be the route that has to be taken. I'm just not
> >that comfortable with that massive a change.
> >
> >Fred
> >
> >
> >On Tue, Feb 7, 2012 at 9:16 AM, Paul Newton <Paul.Newton@pegasus.co.uk
> >wrote:
> >
> >> Fred
> >>
> >> If you DO have to change the calls I would recommend that you take a
> look
> >> at GoFish available on Codeplex ... you would be able to globally change
> >> DateTime( to MyDateTime( etc and then try to achieve what you need in
> the
> >> custom functions MyDateTime(), MyDate(), and MyTime()
> >>
> >> Paul
> >>
> >> -----Original Message-----
> >> From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com
> ]
> >> On Behalf Of Fred Taylor
> >> Sent: 07 February 2012 16:07
> >> To: profoxtech@leafe.com
> >> Subject: Any way to alter the time returned by windows for DATETIME()?
> >>
> >> Any body know of a way to intercept the returns from DATE(), DATETIME(),
> >> TIME() etc. for different timezones WITHOUT changing the Windows setting
> >> for timezone?
> >>
> >> We've moved a bunch of applications to the cloud and now have users
> >> accessing from multiple timezones, but the application wasn't built to
> >> handle that. We can't just change the Windows timezone, as that would
> >> confuse the users with their Outlook calendars, or any other time based
> >> applications. There are 5 applications and they would have about 9,000
> >> places each in
> the code would need to be changed if we have to change the
> >> calls to DATE(), DATETIME(), etc. to use a different function. Most
> >> definitely not looking forward to 45K changes to code!
> >>
> >> Thanks for any insight in to this (huge) dilemma.
> >>
> >> Fred
> >>
> >>
> >> --- StripMime Report -- processed MIME parts --- multipart/alternative
> >> text/plain (text body -- kept)
> >> text/html
> >> ---
> >>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksrO-deF5ODqx6xvJYZ1-vC14e6u9vfEBtCB1aVn5Ofbxw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.