By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
set dateformat 'dmy'
declare @t1 datetime
declare @t2 datetime
set @t1 = current_timestamp
set @t2 = cast('12/11/2019 10:11:12' as date)
select case when month(@t1)<month(@t2) then concat('mese t1:', month(@t1) ,'minore mese t2:',month(@t2)) else 'vice versa' end
| (No column name) |
|---|
| mese t1:2minore mese t2:11 |