The decode always returns the date format in DD-MMM-YY format whereas I want it to return in MM/DD/YYYY format.
select decode(to_date(to_char(SYSDATE,'YYYYMM'),'YYYYMM'),'000000',null,to_date(to_char(SYSDATE,'YYYYMM'),'YYYYMM')) from dual. As of now, when I type this I do not have a proper SQL editor to test the syntax. Hence it may not be correct. However, I could run the decode query in TOAD at my work and that is when I saw it is returning in DD-MMM-YY format. I hope you got some idea as to what my requirement is. Looking forward to your help. Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
