Adding millisecond to date in SAP HANA

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:

datetime function in SAP HANA

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

SAP HANA SQL Functions

Anil SAP Gupta

Published on 06-Dec-2017 17:27:12

• Related Questions & Answers
• Adding a system in SAP HANA Studio
• Adding a package to Delivery unit in SAP HANA
• Adding PUBLIC role to restricted user in SAP HANA
• Adding multiple views in SAP HANA Analytic Privilege
• Adding system archive link in SAP HANA Studio
• Authentication options in SAP HANA while adding new system
• SAP HANA Release/version with date
• Adding columns to output in an Attribute view in SAP HANA
• Adding LCM Administrator role to a user profile in SAP HANA
• Cast string to date in specific format in SAP HANA
• Fetch the modified date of table in SAP HANA
• Information required adding a new remote data source in SAP HANA SDA
• Specify a stop wait timeout (date and time) in SAP HANA
• TCP/IP port in SAP HANA to access SAP HANA XS Engine
• SAP HANA Modeling Perspective in HANA Studio