SELECT to_char(START_D,???)
The issue I have above is that I can't seem to find the right parameter for the above to work. The date is numeric e.g 1102. I want to turn this into a character.
Actually even better is to turn the numeric field to 11/02, which is Day/Month. The reason why I want to turn it into character is that it outputs without the zeros in front. e.g 712 instead of 0712.
Thanks in advance!