08-23-2013 01:46 PM
I have a column named DT_MESSG_FINNCR that contains date like the following :
I want to add a new column named date_mois_annee that would contain the year and month.
I use the following code :
length month $7;
date_mois_annee=catx('-', year(dt_messg_finncr), month(DT_MESSG_FINNCR));
Now my result is 2013-4... what is the proper way to get 2013-04?
Thank you for your help and time.
Need further help from the community? Please ask a new question.