Data retrieval query

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Data retrieval query

Rate Topic

Display Mode

Topic Options

Author

Message

Sandi

Posted 11/1/2005 9:43:05 PM

Junior Member

Group: Forum Members
Last Login: 11/23/2008 1:05:09 AM
Posts: 12, Visits: 28

Hi all,

I want to retrieve last 3 months data from a table,in which datas are loading daily. I have a query but it is retrieving last 3months data + data loaded till current day.But I need only last 3 months data. For example if i am running that job on oct 5 it should retrieve july,august,Sep data. But my SQLquery is retrieving these 3 months data + Oct1,2,3,4 datas also. Please help me to resolve this problem.

Thanks
--------------------------------------------------------------------------------

Post #2865

GreatSushant

Posted 3/8/2006 3:20:57 AM

Junior Member

Group: Forum Members
Last Login: 10/3/2006 2:30:00 AM
Posts: 20, Visits: 1

To add more on this

select current_date;
03/08/2006

select extract(day from date-1);
7

select current_date-extract(day from date-1 );
03/01/2006

select current_date-extract(day from date);
02/28/2006

I think the last query will give you the correct results

SUSHANT P PARICHARAK

Teradata Certified Professional

Post #3692

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:03am