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?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…