Wednesday, August 30, 2006

Teradata extract function

case when b.Branch_Cust_IP is null then extract(year from a.Ruler_Date)
when a.Branch_Cust_IP is null then extract(year from b.Ruler_Date)
else extract(year from a.Ruler_Date) end as shana

No comments: