Oracle date query 1

[CryoGen]

Hi guys, this is my first time in this group, so be gentle. I don't work with Oracle everyday, so I could use an assist here. I need to write a query that will select all fields in a specific view, but only look backwards four days. How might I do that?

 

[Dagon]

It would be something along the lines of:

select * from datetable where mydate > trunc(sysdate)-4

For Oracle-related work, contact me through Linked-In.

 

[SantaMufasa]

CryoGen,

Welcome to Oracle on Tek-Tips !

As you will discover by your returning here to Tek-Tips, the currency we use to thank others for their help is to click the link ("

Thank Dagon for this valuable post!") at the bottom of a helpful post. Dagon was certainly spot on with his help, and he deserves a

.

Good luck !

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[CryoGen]

You are absolutely right. Thanks Dagon, and my apologies for the delay.