Skip to Content
0

SAP HANA Current_Date - Year only

Mar 13 at 04:59 PM

39

avatar image
Former Member

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

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Mar 13 at 05:50 PM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you!

0