I'm having some trouble with formatting a date. I have a varible v_date that contains 9Aug99. I want it to look like this 09-Aug-1999, so here is the code I'm using. v_new_date = format(v_date, "dd-mmm-yyyy"). But what I get is this
9Aug1999. How do I correct this?