+8I would like some features in PostGis database, there is one field called 'dt_desc' with the value (2018-09-04 19:00:20).
But the WARN messege showed in my log: 'dt_desc' cannot be convert to timestamp, and none features is recorded.
I tried change the format in FME writer to timestamp, varchar, date...but the problem continue again
In my PostGis database the format for this field is timestamp.
Somebody can help me?
Thank´s
Best answer by takashi
Hi @mr_fme, try formatting the datetime value with the Standard FME Date/Time Format (i.e. %Y%m%d%H%M%S) before writing.
Generally FME automatically converts a date/time string with the standard FME date/time format to an appropriate value according to the destination data format - PostGIS in this case.
Hi @mr_fme, try formatting the datetime value with the Standard FME Date/Time Format (i.e. %Y%m%d%H%M%S) before writing.
Generally FME automatically converts a date/time string with the standard FME date/time format to an appropriate value according to the destination data format - PostGIS in this case.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
