Question
query date from odbc
+10- Contributor
I have an odbc connection and am trying to return the new records from the last 24 hours. I think I keep running into issues on how to format the SQL statement.My plan is to run this daily and only geocode the newest records in the past 24 hours. Thanks!
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.
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.
+10- Contributor
Hi David,
I've tried many statements and different transformers so I don't have one error message I can show you since I'm still pretty new at FME and not sure where to put the statement (once I figure it out). What I was trying to do a query on my table (named lwmain) and I have a field/attribute with date and time in it (named dtrepor) and only geocode the new records- I have the rest of the transformers I need working to get the correct writer.
Thanks.
Alice
+53- Evangelist
Presuming that this query is the starting point for your workbench I would use an sql creator with a query along the lines of
Select * from lwmain where dtrepor > sysdate -1
+10- Contributor
Thanks E.Gomm- That was exactly what I was looking for and it worked like a charm.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.