+48Hi,
I'm writing data to a MySQL (non-spatial) database and have some problems getting datetime fields filled. Checking a sample table in phpMyAdmin shows the date format to be ^Y-^m-^d ^H:^M:^S, e.g. 2017-02-28 13:09:00, so I've set up my TimeStamper to output that. But when I write to the database it fails every feature with a message saying it's an invalid format.
If I enter the same value directly through phpMyAdmin it's accepted.
Any idea what I'm doing wrong?
Best answer by david_r
Try formatting your timestamps as "FME Date/Time (^Y^m^d^H^M^S)" before the writer.
Try formatting your timestamps as "FME Date/Time (^Y^m^d^H^M^S)" before the writer.
+48Try formatting your timestamps as "FME Date/Time (^Y^m^d^H^M^S)" before the writer.
Current versions of FME (up to and including 2016) has a "fake" interpretation of timestamps, where they're represented as strings internally, not floats. It is the writer that ultimately converts that string into whatever format the target requries, and when doing that it assumes that the incoming string be supplied as "FME Date/Time" or some variant thereof.
Someone from Safe please correct me if my assumptions are wrong :-)
+19
You can always use python. Then format in the python code to exactly how you want. Their is a ton on this.
https://docs.python.org/2/library/datetime.html
import time
from datetime import date
today = date.today()Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
