I am able to format these values as desired by utilizing the String function leftpad(), available in the Denodo XtraFuncs for VDP Library.
If you are a valid support user, you can download the Denodo Xtrafuncs for VDP from
the Support Site under Downloads > DenodoConnects > Denodo XtraFuncs for VDP.
Using this function, I can specify the desired ‘size’ of my outputs, and which character will be used to fill the difference.
`SELECT leftpad('month_column', 2, 0) FROM 'table_name';`
Will return a value of ‘1’ as ‘01’, ‘3’ as ‘03’, ‘11’ as ‘11’ and so on.
Please refer to the [Denodo XtraFuncs - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20XtraFuncs%20-%20User%20Manual#h.2ug4voy6nagh) for more on the definition and usage of these functions.
Hope this helps!