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

Thread: how to change the date format...

  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Angry

    Hi,


    How to change the date format in Oracle. Could U please help me...


    thankx
    mustak

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    for your session, you can use :
    ALTER SESSION SET NLS_DATE_FORMAT='...'
    where ... is the format you want, for example
    HH24:MI:SS for hours on a 24h format, minuts, seconds : 18:31:43
    DD/MM/YYYY gives day/month/year : 25/07/2001

    if you want to change for the whole instance, add NLS_DATE_FORMAT='...' in your init.ora file

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