Skip to Content
0

Import from excel, date format problem

Nov 02, 2016 at 09:31 AM

44

avatar image

Hello,

I am trying to import data from Excel into a db table using the "Import" hdbstudio tool. One of the table columns is a Timestamp, and the corresponding Excel column type is "Date".

I get this error:

Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

How can I resolve this?

Thanks

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

1 Answer

Best Answer
Ilaria Spina Nov 02, 2016 at 11:09 AM
0

By manually adding the hour in input file (00:00:00) I resolved, but I hope there is some other way

Share
10 |10000 characters needed characters left characters exceeded