Skip to Content
avatar image
Former Member

SAP HANA Current_Date - Year only

Hi All, does anyone know a way of pulling just the current year from CURRENT_DATE function in SAP Hana?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 13 at 05:50 PM

    Doing a lookup in the official documentation you would find a function called YEAR. With that you can "extract" the year from the current date.

    select YEAR(CURRENT_DATE) from dummy;

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded