You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hop.apache.org by "hansva (via GitHub)" <gi...@apache.org> on 2023/02/09 15:34:28 UTC

[GitHub] [hop] hansva opened a new issue, #2298: [Bug]: Snowflake bulk loader doesn't format dates and timestamps correctly

hansva opened a new issue, #2298:
URL: https://github.com/apache/hop/issues/2298

   ### 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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org