Error in Populating TimeF ield in HANA DB

[mantrishekar]

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

[JWootton]

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