-
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|