HANA SQL- MAP Function

MAP ( )- works similar to IF..THEN…IF…..THEN…ELSE 

---

The test program that calls the AMDP method.

---

CURRENT_DATE– returns the current date(YYYY-MM-DD).

TO_DATS( )– converts the date(YYYY-MM-DD) to system date format like YYYYMMDD

DAYNAME ( )– function returns the day name of the date(YYYY-MM-DD).

MAP( )– Function receives an argument(first) and  if…then…if..then…….else. Below as shown depending on dayname it returns the day number of within the week.

---

From timestamp we can get the date and time using TO_DATE( ) & TO_TIME( ) functions.

---