Skip to main content
Archived

MS SQL parameter to ignore 'alleged' datetime issues

Related products:Integrations
  • August 3, 2020
  • 0 replies
  • 22 views
S

FME dates are irritating when working with MS SQL as I can handle dates more effectively in MS SQL.

I have a workbench that processes 100+ CSV files, each file has a different structure so I process each file dynamically.

Dates can be formatted as 19 Sep 2011 13:09:00 or 19 Sep 2011 13:09 which MS SQL is happy enough with but FME isn't.


At the moment I use a Python script to load the full file and do a regex replace to resolve the FME date issue.

It's really bad that FME simply nullifies any date issue so it is quite possible we are unaware of issues.

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.

Community Stats

32,657
Posts
123,933
Replies
41,067
Members
Terms & ConditionsAccessibility 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.