Question Re: HANA SQL SCRIPT MONTHS_BETWEEN Function is not working in Technology Q&A

HANA SQL SCRIPT MONTHS_BETWEEN Function is not working

Former Member — Sun, 12 Mar 2017 16:22:43 GMT

Hi All,

I tired the below HANA SQL standard function to get difference between two dates but it is working only for "DAYS_BETWEEN" not for Months and Years. I followed the below SQL reference

http://help-legacy.sap.com/saphelp_hanaplatform/helpdata/en/9f/9eb73468b04bbc9d6014d22d2bfb90/content.htm

Error Log

I got some solution from SCN https://archive.sap.com/discussions/thread/3877237

As i am working on Demo Hana cloud server i am not able to access it .

My question is why the standard date function " MONTHS_BETWEEN" and "YEARS_BETWEEN" are not working as "DAYS_BETWEEN?

Thank you All 🙂

Re: HANA SQL SCRIPT MONTHS_BETWEEN Function is not working

pfefferf — Sun, 12 Mar 2017 18:11:41 GMT

Both functions MONTHS_BETWEEN and YEARS_BETWEEN are added to HANA with HANA 1.0 SPS12. So I assume you are on a lower release level (DAYS_BETWEEN is already available since some SPS).

The link to the (legacy) online documentation, points to HANA 2.0 SPS00 in which the functions of course available too.

Regards,
Florian

Re: HANA SQL SCRIPT MONTHS_BETWEEN Function is not working

Former Member — Mon, 13 Mar 2017 05:29:14 GMT

Thanks for your reply : ) . Yes it's current version in 1.00.097 . I am using SAP HANA trail version . Is HANA 2.0 is available in HANA trail version? You have any idea about it ?

Re: HANA SQL SCRIPT MONTHS_BETWEEN Function is not working

pfefferf — Mon, 13 Mar 2017 05:34:36 GMT

Seems like you are using a shared HANA instance which is still on HANA 1.0 SPS9 level. The HANA MDC instance available on SAP CP Trial is at level HANA 1.0 SPS12.

Re: HANA SQL SCRIPT MONTHS_BETWEEN Function is not working

Former Member — Mon, 13 Mar 2017 15:41:36 GMT

Thank you so much 🙂 HANA MDC Trail instance is working perfect .