- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 TESTThis 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:
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
- SAP HANA Release/version with date
- Authentication options in SAP HANA while adding new system
- 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
Advertisements