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