java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

Document created by Terese_Baker Employee on Mar 24, 2015Last modified by dave_lesshafft on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
The error " Errors occurred constructing SQL statement.; Caused by: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" occurs on a database connector.
Please consider the following:
  • Is there a database profile field configured as Date/Time but the actual database value is not a Date/Time, i.e. Character?
  • Do you have fields defined in your profile for all the fields listed in your select statement?
  • Is the order of the fields in your select statement the same as the fields listed in your profile?
1 person found this helpful

Attachments

    Outcomes