We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

BD Store node into Oracle dropping Milliseconds

Comments

2 comments

  • Avatar
    Adrian Williams

    Have you considered using the JDBC Execute node as an alternative?

    What is the data type of the field within the database table? The field needs to be a TIMESTAMP rather than a DATE.

    0
    Comment actions Permalink
  • Avatar
    Gerry Mullin

    Just backing up what Adrian has said above with a link from stack overflow. Date stores to nearest second, Timestamp is for millisecond. It's discussed here.

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.