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

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.