Timezone modifications

[Guest]

If you are sitting in the pacific time zone and have logged into a data server in the eastern time zone, how can you make your computer read the time zone time stamps of the data when it was created in the eastern time zone? basically if you log into a database in a different time zone, your excel query bring back data with a time stamp aligned with the timestamp of your computer and not the timestamp of the computer where the data resides.This is important because the moment the data is generated it is given a timestamp inthe time zone it was generated in. Your query in the pacific time zone should not associated the pacific time zone with the data that was generated in the eastern time zone.

Please rerspond back when you have a moment.

 

[jaf]

The native time zone of Windows & the internet is UCT or GMT.
However, getting to it is sometimes a PIA.

All I can suggest is, if it creates a problem for you, make the time stamps
UCT.


--
John
johnf 202 at hotmail dot com


| If you are sitting in the pacific time zone and have logged into a data
server in the eastern time zone, how can you make your computer read the
time zone time stamps of the data when it was created in the eastern time
zone? basically if you log into a database in a different time zone, your
excel query bring back data with a time stamp aligned with the timestamp of
your computer and not the timestamp of the computer where the data
resides.This is important because the moment the data is generated it is
given a timestamp inthe time zone it was generated in. Your query in the
pacific time zone should not associated the pacific time zone with the data
that was generated in the eastern time zone.
|
| Please rerspond back when you have a moment.