Skip to Content
0

How to use current date in SQL query while connecting from Lumira to SAP

Feb 12, 2017 at 01:29 AM

145

avatar image

Hi -

I am connecting from Lumira to SAP and trying to retrieve some data using SQL (underlying database is Oracle). Everything works fine if I use a hardcoded date value but I need to use a dynamic date in SQL and I do not know how can I get that working. Here's the SQL that is working...

select * from <infosetname> where "infoset.SLFDAT" > DATE'2017-01-01'

My requirement is to get all the records for rolling 3 months and therefore, I need something like...

select * from <infosetname> where "infoset.SLFDAT" > [current date - 90 days]

I am not familiar with the freehand SQL...so, looking for some assistance.

Can someone please help!

Thanks,

Arun

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arun S Feb 13, 2017 at 12:08 PM
0

Anyone? Hope this is the right forum to post the question...

Share
10 |10000 characters needed characters left characters exceeded
Ludek Uher
Mar 01, 2017 at 06:19 PM
0

Does the query (select * from <infosetname> where "infoset.SLFDAT" > [current date - 90 days]) work in Oracle?

Does it work in IDT?

- Ludek Senior Support Engineer AGS Product Support, Global Support Center Canada

SAP is now offering chat support for specific product components. For more details please see the KBA 2213344 - How to start a chat with SAP Support[video]

Follow me on Twitter: https://twitter.com/crnanalysistips

Got Enhancement ideas? Use the SAP Idea Place: https://ideas.sap.com/SAPLumira/boards

Share
10 |10000 characters needed characters left characters exceeded