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
Printable View
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
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
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 ...