Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select floor(
  (
    months_between(
      CAST(TO_TIMESTAMP_TZ('2022-07-01T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE), 
      CAST(TO_TIMESTAMP_TZ('2022-01-11T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE)
    )
  ) /12
) as result
from dual;


RESULT


0


select months_between(
  CAST(TO_TIMESTAMP_TZ('2022-07-01T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE), 
  CAST(TO_TIMESTAMP_TZ('2022-01-11T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE)
) / 12 as result
from dual;


RESULT


.4731182795698924731182795698924731182792


select trunc (
  months_between(
    CAST(TO_TIMESTAMP_TZ('2022-07-01T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE), 
    CAST(TO_TIMESTAMP_TZ('2022-01-11T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE)
  ) / 12
  , 1
) as result
from dual;


RESULT


.4


select floor (
  months_between(
    CAST(TO_TIMESTAMP_TZ('2022-07-01T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE), 
    CAST(TO_TIMESTAMP_TZ('2022-01-11T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE)
  ) / 1.2
) / 10 as result
from dual;


RESULT


.4


with
  function floor_ish(p_value number, p_radix number) return number is
  begin
    return floor(p_value * power(10, p_radix)) * power(10, -p_radix);
  end;
select floor_ish (
  months_between(
    CAST(TO_TIMESTAMP_TZ('2022-07-01T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE), 
    CAST(TO_TIMESTAMP_TZ('2022-01-11T00:00:00+05:30','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS DATE)
  ) / 12,
  1
) as result
from dual;


RESULT


.4