Oracle SQL query

[Miguel Orrego]

Hi,

My Oracle sql isn't very good, I need to select from a table events that
occurred + / - 28 days from now.

So, SELECT blah from table_blah where date = sysdate

Would give me events now, how do I modify this for + / - 28 days?

Thanks.

select * from blahdiblahdiblah where datecolumn between
sysdate -27 and sysdate -29;

>-----Original Message-----
>Hi,
>
>My Oracle sql isn't very good, I need to select from a

table events that

>occurred + / - 28 days from now.
>
>So, SELECT blah from table_blah where date = sysdate
>
>Would give me events now, how do I modify this for + / -

28 days?

>
>Thanks.
>
>
>.
>