Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum




Message Posted: Thu, 28 Jun 2007 @ 23:07:48 GMT





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




Subj:   Re: How to get 5 digit month diff
 
From:   Victor Sokovin



  Looks like if number of months between two dates is greater than 4 digit, then this would not work. Any work around?  


That is indeed the limit for the INTERVAL data type. If you expect more than 4 digits you'll have to do some math on your own. Good luck.


Regards,

Victor





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

Recent Threads

Attachments

Library

Quick Reference

Useful Links

Rules of Conduct

FAQs

Join the Forum

 

Archives

Sample Index

2008  2003
2007  2002
2006  2001
2005  2000
2004  1999 

 

2007 Indexes

Jan  Jul
Feb  Aug
Mar  Sep
Apr  Oct
May  Nov
Jun  Dec


 
 
 

 
 
 		 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 09 Nov 2008