I have a date field: TRANSACTION_DATE
I would like to return the year and month number separated by a dash to create a new column that would look like (not the month name):
2012 - 001 (January)
2012 - 002 (February)
2012 - 003 (March)
2012 - 011 (November)
Would someone shoe me how I can do this?
Thank you much.