Adding millisecond to date in SAP HANA

I have written a SP that saves current timestamp in a variable. In SAP HANA, following functions are there to add an amount of time to a date:

If I have to add amount of ms to a date so if there is a way to achieve this?

0 0

1 Answer

Anil SAP Gupta

Answered on 6th Dec, 2017

Try using ADD_SECONDS function as below:

SELECT ADD_SECONDS (TO_TIMESTAMP('2017-07-15 02:17:15'), 0.1) FROM TEST

This will add seconds as fraction value as requested. Below is syntax and example:

ADD_SECONDS

Syntax

ADD_SECONDS (t, n)

Description

Computes the time t plus n seconds.

Example:

SELECT ADD_SECONDS (TO_TIMESTAMP ('2012-01-01 23:30:45'), 60*30) "add seconds" FROM DUMMY;

add seconds

2012-01-02 00:00:45.0

To know more about ADD_SECONDS function, you can also refer this link:

To know more about SQL functions in SAP HANA system, you can also refer our HANA tutorial:

0 0