Skip to main content
Solved

Problems to write field date in Postgis Database

  • September 5, 2018
  • 1 reply
  • 77 views
mr_fme
Enthusiast
Forum|alt.badge.img+9

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

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • September 5, 2018

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.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.