Hacker News Reader

Comment by btilly | Hacker News Reader

Try it again, except looking for months. You'll get -11 instead of 1.

    select extract(month from justify_interval(timestamp '2022-01-01' - timestamp '2021-11-01'))

returns 2