Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Easy way to select last 30 days based on DATE column?

Easy way to select last 30 days based on DATE column?

From: Rhugga <chuck.carson_at_gmail.com>
Date: 22 Jul 2005 16:14:42 -0700
Message-ID: <1122074082.023345.318880@g43g2000cwa.googlegroups.com>

I want to grab all rows from a table that have a DATE value within the last 30 days. (thus it can span 2 months at any given time)

Is this possible with a simple select or do I need to build more logic in the application?

Thx,
CC Received on Fri Jul 22 2005 - 18:14:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US