Skip to Content

Import from excel, date format problem

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 02, 2016 at 11:09 AM

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

    Add comment
    10|10000 characters needed characters exceeded