DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: diffrent - Timestamp

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    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


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    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
  •  


Click Here to Expand Forum to Full Width