Hi Przemek,
No, I am not aware of a database that stores time zone with the
date/time value. I agree with Viktor - The date/time value stored in
the database must be timezone independent (ie. UTC 0). Then, the app
can set some value (eg. environment var) to align any date/time
values read from the database with the user's timezone (this should
happen automatically at the RDD level). So, all date/time values in
memory (including the current record buffer) will be adjusted for the
current timezone while date/time values in the database will not.
Regards,
Randy.
At 01:20 PM 2/12/2009, you wrote:
On Thu, 12 Feb 2009, Randy Portnoff wrote:
Hi Randy,
> Sorry if this was already covered, but the time zone should also be
> included in the datetime value and considered by the date-time
> functions/operators.
But can you say sth more.
Which timezone we should set when DATETIME value is extracted from table,
f.e. ADT or DBF file or from some SQL RDBMS. Which database systems you
know that supports timezone or UTC offsets or at least binary UTC time
signature in DATETIME values? Or maybe they have some strict rules used
for DATETIME representation in tables, f.e. always safe them after conversion
to UTC+0000.
best regards,
Przemek
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
