Skip to main content
Solved

Comparing two dates types

  • March 11, 2024
  • 1 reply
  • 58 views

fbrenn
Contributor
Forum|alt.badge.img+6

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:

 

View original
Did this help you find an answer to your question?

1 reply

nielsgerrits
VIP
  • Best Answer
  • March 11, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings