Skip to main content
  • EN

I 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

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.

Reply


Community Stats

29,723
Posts
112,933
Replies
37,373
Members
Terms & ConditionsCookie settings