Skip to main content

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!

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:

 


Reply