I am a FME beginner, trying to load timestamp before the year 1000 in a Vertica database, using JDBC driver.
Using:
@DateTimeParse(@Value(myDate), FME)
an error raise:
Table1_FeatureWriter_c058446b_6d16_48db_85ad_d913e88f07e526: '1' is out of range for 'year'. Range of 'year' is from '1000' to '9999'
Table1_FeatureWriter_c058446b_6d16_48db_85ad_d913e88f07e526: Failed to evaluate expression '@DateTimeParse(00010101000000, FME)'. Result is set to null
How to insert those dates?
Many thanks, best regards.