where clausule on date field

dataservices sap-erp-bw
1

I need create a where condition on query to retrieve all data inserted in my database but the data that I want retrieve are yesterday data.

cbuendia (BOB member since 2010-10-15)

2

where DATAB >= sysdate()-1
:?:

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks for your help but when I run my infopackage, don´t retrieve data I supose that the format no is correct.

My Date Column have the format YYYY.MM.DD and think that when use sysdate()-1 only retrieve the day number.

I print a trace messages but I can´t see the sysdate value.

Any Idea.

Thanks

cbuendia (BOB member since 2010-10-15)