[Bug]: Snowflake bulk loader doesn't format dates and timestamps correctly

[hansva]

Apache Hop version?

2.1

Java version?

11

Operating system

Windows

What happened?

Import: https://issues.apache.org/jira/browse/HOP-4495

The COPY INTO command only accepts a very specific format for Dates/Timestamps.

See: https://docs.snowflake.com/en/sql-reference/parameters.html#label-timestamp-output-format

It would as such be better to just format the dates in the temporary files to that format (For reference: yyyy-MM-dd HH:mm:ss.SSS)

Issue Priority

Priority: 2

Issue Component

Component: Database