Seeded interface dropping time on upload
Hi all
Just running some tests using desktop integrator to load meter readings to CSI_CTR_READINGS_INTERFACE, on 12.2.5.
So far so good, data gets loaded cleanly with no obvious issues.
However on closer inspection I can see that the field "VALUE_TIMESTAMP" is being modified on upload. I've tried supplying the data in excel in the following formats
| VALUE_TIMESTAMP | COUNTER_READING | COMMENTS |
| * Date | Number | Text |
| 2017-Dec-12 14:15:00 | 615 | YYYY-MMM-DD hh:mm:ss |
| 12-Dec-2017 14:15:00 | 616 | dd-mmm-yyyy hh:mm:ss |
| 12/12/2017 14:15:00 | 617 | dd/mm/yyyy hh:mm:ss |
| 12/12/2017 14:15:46 | 618 | mm/dd/yyyy hh:mm:ss |
But in each case when I query the interface table the time segment is replaced with 00:00:00
1