Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 16 Mar 2003 @ 19:55:05 GMT

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

Subj:   Re: SQL to calculate tenure in months
From:   Burton, Bruce

Thanks Dennis but I'm getting an error in queryman for:

(date '2003-01-31' - orgnl_srv_dt) interval month(4)
from subsrptn

Code = 3706.
3706: Syntax error: expected something between ')' and the 'interval' keyword.

orgnl_srv_dt has the date format. I also tried to make this work using a update date field on the same table to make sure the date '2003-01-31' was not causing problems. I may be overlooking something very simple here but cannot figure it out.

The NCR documentation is not very straight forward on this and I've scanned the web but no good examples of an interval between two dates.



  <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: 28 Jun 2020