Months_Between equivalent

1

Hi,

In Oracle I’ve often used the function Months_between (, )

I get a number value returned.

Is there an equivalent method to get this in Dremio?

I’ve tried date_diff but it doesn’t return numbers and casting to number fails.

Any help would be appreciated.

2

@myaccount, welcome to the Dremio Community!

There is a MONTHS_BETWEEN() in Dremio :slight_smile:

SELECT MONTHS_BETWEEN (TO_DATE (‘2003/01/01’, ‘yyyy/mm/dd’), TO_DATE (‘2003/03/14’, ‘yyyy/mm/dd’) )

image
image898×242 17 KB

3

Thank you so much for the quick reply :slightly_smiling_face:

Is there a reason this isn’t in the documentation of functions?

https://docs.dremio.com/software/sql-reference/sql-functions/ALL_FUNCTIONS/?parent=sql-functions

I think I made a false assumption that if it’s not in the documentation it doesn’t work. Thanks again for clarifying…

4

@myaccount I think your assumption is right that it has to be documented, I have opened a ticket with our docs team to get it added

5

Thanks for getting this added.

6

@myaccount Here you go: Dremio