Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 21:15:33 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Auto Setting the Current Date
 
From:   Jay Quinn

Hi,here is a sample SQL where I specify a date, it's 3 days after todays date.

select count(distinct(ban))
from vslc007_billing_account
where sys_creation_date <= '20020126'

What can be done to make that date automated in respect to everytime it's ran it's always going to be 3 days after the current day? I don't want to hand change it and 36 others every 2 weeks.

Thanks, Jay



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016