Hi All, I have my date format as 08-Mar-2014 how to I change it to 08-03-2014? Can I use regexp_replace.
I tried below but not getting the desired output. regexp_replace(started_dt,"\Jan|\Feb|\Mar|\Apr|\May|\Jun|\Jul|\Aug|\Sep|\Oct|\Nov|\Dec","\01|\02|\03|\04|\05|\06|\07|\08|\09|\10|\11|\12") Output: 09-1|2|3|4|5|6|7|8|9|10|11|12-2014 16:19:56. Help is much appreciated. Thanks Krishnan