diffrent - Timestamp

[Kumud]

In my datawarehouse I am getting data from diffent location.
Timestamp may be PST, EST, GMT .....
How can I retrive data or compare or convert ????
Also how I sort on timestamp.

Does any body has done like this ?
Your help is appriciated

[pando]

I believe you can use NLS_TERRITORY in to_date(), check the docs

if you use sql loader then use to_date function to conver the time to that country's time or whatever you are looking for

[Kumud]

Thanks pando , I check nls parameter it says nls_date_format or nls_date_languge which is like american, french, german etc... but it does not say any think about PST, GMT, EST ...