OraFAQ Forum: SQL & PL/SQL » Finding Records 60 days back from sysdate

Home » SQL & PL/SQL » SQL & PL/SQL » Finding Records 60 days back from sysdate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding Records 60 days back from sysdate [message #454]

Wed, 13 February 2002 08:57

Tom
Messages: 67
Registered: June 1998

Member

Hi,

I have a simple question. I need to select records
that are within 60 days back from the sysdate. So basically
a select statement:

Select partnum from part_table
where to_date >= sysdate - 60 days

How do I write the where clause?

Report message to a moderator

Re: Finding Records 60 days back from sysdate [message #457 is a reply to message #454]

Wed, 13 February 2002 12:44

Mike
Messages: 417
Registered: September 1998

Senior Member

without "days" your statement will work correctly:

Select partnum from part_table
where to_date >= sysdate - 60

Report message to a moderator

Re: Finding Records 60 days back from sysdate [message #479 is a reply to message #457]

Thu, 14 February 2002 23:17

Abul Fazal
Messages: 39
Registered: February 2002

Member

Select partnum from part_table
where trunc(to_date('column_name', 'Format')) >= trunc(sysdate - 60 )

Is a safer option in that the time will be ignored.

Report message to a moderator

Previous Topic:	loops and cursors
Next Topic:	improving performance of a query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 09:56:01 CDT 2024