SAP HANA SQLScript · Date & Time Processing

You need to store a point in time accurate to whole seconds, with no fractional part. Which of DATE, TIME, SECONDDATE, TIMESTAMP fits, and what is the trap?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Date & Time Processing

What does each return with TO_VARCHAR? ``` TO_VARCHAR( TO_TIME('13:07:38'),'HH12') TO_VARCHAR( TO_TIME('13:07:38'),'SSSSS') ```

This insert fails. Why, and how do you fix it? ``` INSERT INTO dates VALUES('01=02=2017'); ```

What does each expression return for the date 2018-12-27? ``` TO_VARCHAR(d,'RM') TO_VARCHAR(d,'MON') TO_VARCHAR(d,'DDD') ```

These are ABAP DATS strings, VARCHAR(8) in YYYYMMDD form. What are the two deltas? ``` '20180618' - '20180601' '20180101' - '20180601' ```

What does DAYS_BETWEEN('2017-12-01', '2017-12-08') return, and how is the sign decided?

You want the day-of-month as an integer. EXTRACT(DAY FROM d) works, but DAY(d) reports 'function not found'. What is the standalone function called?

Start learning today

Free to start — download the app or use it in your browser.