How to Create A Date From Preceding Date?
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Analytical Applications » How to Create A Date From Preceding Date?
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.


How to Create A Date From Preceding Date? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Benjamin See
Posted 10/4/2007 3:47:25 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48, Visits: 20
Dear Who Can Help,

I had a table look like this:
********************************
Cust_Id || Start_Date || End_Date
803 || 2007-04-29 || 2007-05-01
803 || 2007-05-02 || 2007-05-03
803 || 2007-05-04 || 2007-05-07
803 || 2007-05-08 || 2007-06-02
********************************

I need to create a new column using the preceding End_Date like this:
********************************
Cust_Id || Start_Date || End_Date ||New_Date
803 || 2007-04-29 || 2007-05-01 ||
803 || 2007-05-02 || 2007-05-03 || 2007-05-01
803 || 2007-05-04 || 2007-05-07 || 2007-05-03
803 || 2007-05-08 || 2007-06-02 || 2007-05-07
********************************
Please note that the New_Date was taking the previous End_Date.

How to use SQL to create a new column like above?

Many Thanks in Advance!

Regards

BS
Post #9112
dnoeth
Posted 10/5/2007 2:48:36 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Yesterday @ 7:20:23 AM
Posts: 533, Visits: 282
Hi Benjamin,
this is a task for OLAP:
MIN(end_date) OVER (PARTITION BY Cust_Id ORDER BY end_date
ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)


Dieter
Post #9128
Benjamin See
Posted 10/5/2007 5:23:45 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48, Visits: 20
Dear dnoeth,
It work ok.

Thank you very much ^_^

Regards

BS
Post #9139
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
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 3:01pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.234. 10 queries. Compression Disabled.