Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    toronto
    Posts
    3

    Unanswered: How to set sysdate in instance level on window2000?

    I want to make sysdate show as 'mon-dd-yyyy hh:mi:ss' . Can you tell me some solution?

    Thanks in advance

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    change nls_date parameter or use to_char function to display as you like.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2003
    Location
    toronto
    Posts
    3

    how to set sysdate as 'mon-dd-yyyy hh:mi:ss'

    I want to set the parameter nls_date_format as
    'mon-dd-yyyy hh:mi:ss'. I saw a solution that I can change the registery by adding an item under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE setting the string value with nls_date_format and setting value data with 'mon-dd-yyyy hh:mi:ss'.I tried and there was no reponse at all. Can someone tell me how to resolve my problem?
    Thanks in advance!

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
    "NLS_DATE_FORMAT"="DD-MON-RRRR"

    Or do as "The_Duck" Suggested


    HTH
    Gregg

  5. #5
    Join Date
    Nov 2003
    Location
    toronto
    Posts
    3

    How to set sysdate?

    I want to change the sysdate persistent. Therefore, to_char function and "alter session set nls_date_format..." are not work. I tried the ways you guys told me. It is still no positive response. So I really got lost!!!

Posting Permissions

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