Skip to Content
0

Error in Populating TimeF ield in HANA DB

Dec 23, 2016 at 06:33 AM

89

avatar image

Hi All,

I am trying to implement Smart Data Streaming.

In my input file i have Three columns and last column is Time Value.

When am trying to insert data through SDS Project File Import using CSV every record is inserting properly but for the time value it is adding 6.5 Hours time for the actual time.

Could anybody please help me to resolve this issue.

Regards,

Shekar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jeff Wootton
Jan 03, 2017 at 05:10 PM
0

This is due to time zone conversion. See the doc discussion on time zones. If the input doesn't explicitly specify the time zone, the server will assume time values are local and will convert them to UTC

Share
10 |10000 characters needed characters left characters exceeded