query date from odbc
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!
Userlevel 4
- 8175 replies
-
12 August 2015
Hi
What is the statement you're currently using and what is the error message?
David
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
Userlevel 1
+21
- Contributor
- 3079 replies
-
13 August 2015
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
Thanks E.Gomm- That was exactly what I was looking for and it worked like a charm.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.