To break down my question to a very simple SQL:
How can I modify this to always return a two-digit month? For example, in Feb I would like to see '02' instead of '2'. I was trying to play around with CAST to see if that would do it but I haven't got it right.
Thanks in advance.
Code:
select char(year(current_date)), char(month(current_date)) from sysibm.sysdummy1
Thanks in advance.
Comment