I have a column with interval year to month
datatype. With Extract
function I get only month value from interval. But how to get full month (year * 12 + month)?
I can use Extract
for year, multiply it by 12 and add it to the extracted month. But how to do it simply, using 1 function?