Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    india
    Posts
    1

    Unanswered: to get GMT time in oracle 8i

    how can i get GMT time in oracle 8 i .in oracle 9i sys_extract_utc function gets the GMT time. but how to get GMT time in oracle 8i.there is function new_time(sysdate,'UDT','GMT') which we can use to calculate GMT if we know the locale like UDT but what if we don'nt know . is there anyway to get GMT time if we want to calculate it for any locale

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    how does that 9i function work?! I didn't know about that!!

    for 8i, if you are on unix, then I have a solution for you.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Oct 2003
    Posts
    22

    Re: to get GMT time in oracle 8i

    TIMESTAMP WITH TIME ZONE, will display session time with respect to GMT time. Use that function to manipulate and display GMT time.
    Last edited by stephen_pe; 10-17-03 at 14:14.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •