I don't think so. I think the datetime values in SQL Server and VFP do
not have a timezone attribute built-in, a feature I complained about in
the Hacker's Guide. I wasn't aware that Oracle did this, but I know
PostGreSQL supports a timezone attribute as well
Andrew Coates and I batted around the issue of calculating time zone
information on the Wiki, in the topic
http://fox.wikis.com/wc.dll?Wiki~XMLDateTime~VFP, and there's also an
interesting bit at
http://fox.wikis.com/wc.dll?Wiki~XMLTimezoneClass~VFP that could be
converted to store all times as Zulu ("GMT" or "UTC") time. That should
let you properly calculate elapsed time for employees who clock in at
one time zone and clock out in another, a situation more common than
most expect.
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com
On Nov 3, 2004, at 10:41 AM, Andy Davies wrote:
>
> Can't datetime values be absolute (i.e. gmt/zulu time) with their
> _display_
> controlled by e.g. Win local settings - I'm pretty sure that's how they
> work in Oracle?
>
> AndyD 8-)#
©2004 Ted Roche |
