If you are moving from Microsoft SQL Server to Snowflake you'll likely be moving some datediff sql statements over, datediff(m, date, date) gives the number of months between dates in Microsoft SQL Server - However in snowflake the syntax is different.

However something odd is the datediff will accept the datediff(m, date1, date2) syntax and instead of giving an error seems to give something along the lines of number of minutes between the dates (although it's not minutes).

If you are doing math based on this then this can lead to some numbers that look like they are completely wrong!