Solved

Comparing two dates types

Forum|Forum|1 year ago
March 11, 2024
1 reply
101 views

+7

fbrenn
Contributor

Hello!

Here is my problem:

I have a SDE db (let’s call it T1) with field “date_change” (type: date). I also have a table (let’s call it T2) that has a filed “sync_date” (type: date).

I am trying to make a query where I select all features from T1 where “date_change” is equal or greater than T2 “sync_date”.

I am using a FeatureReader and trying to apply it on the where clause. However, my query keeps coming blank. I think the syntax is wrong (WHERE clause: “date_change” >= “sync_date”).

Anyone has any suggestions?

Thank you in advance!

Best answer by nielsgerrits

You probably have to reformat the date. FME reads date as %Y%m%d%H%M%S where SDE might be expecting something like %Y-%m-%.

See this topic:

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.