(Absolute novice here - please bear with!)
I have two columns in a query, one with Month Number (t.month) and one with Year Number (t.year). Is there a way to combine them together to make a DATE format - ie '(t.year)-(t.month)-01'
my (t.month) number is smallint type which means I imagine there may be an issue when months are single digit numbers?
Thank you :)