Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Smile Unanswered: DD-MONTH-YY ..ny pblm?

    Hi

    Select sysdate from dual;

    o/p - '05-DEC-03'.

    I wanna get the result as '05-DECEMBER-03'.

    I tested by giving the date format 'DD-MONTH-YY'..
    but it gives me the same output..

    help me??

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai
    Posts
    12
    select to_char(sysdate,'DD-MONTH-YY') from dual

    hope this helps...

    sk

Posting Permissions

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