Skip to Content
avatar image
Former Member

Importing date value from excel into HANA MDC table ?

I am not able to import records of type date into table. I am not getting any error but there are no values being imported or shown when I execute select query on the table.

I am attaching few screen shots on how I am doing it, if there is any formatting error related to date format then please let me know which is the correct or right way to do it.

Table: _USR_DATE

Excel file: No headings, only Date values in YYYY-MM-DD format (language - UK using format cell option)

Note: Further I want to use time stamp data type in my table and import the same, what different do I need to do in this case.

h0.png (15.8 kB)
h1.png (2.8 kB)
h2.png (30.8 kB)
h3.png (19.5 kB)
h4.png (8.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers