How to get the first day of the month

suppose i have

the period as JAN-13

how to get 1.1.2013
pardeshirahulAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Try this:
select to_char(to_date('JAN-13','MON-YY'),'fmMM.DD.fmYYYY') from dual;

The fm removes the '0' from '01'.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.