topic Re: How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150888#M2574 <HTML><HEAD></HEAD><BODY><P>I think you can subtract dates in Teradata to get # days difference.&nbsp; If the data are timestamps, you might need to cast as date before subtracting.</P></BODY></HTML> Mon, 15 Dec 2014 18:45:31 GMT DBailey 2014-12-15T18:45:31Z How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150887#M2573 <HTML><HEAD></HEAD><BODY><P>How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata</P></BODY></HTML> Mon, 15 Dec 2014 17:35:36 GMT https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150887#M2573 venkatnaveen 2014-12-15T17:35:36Z Re: How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150888#M2574 <HTML><HEAD></HEAD><BODY><P>I think you can subtract dates in Teradata to get # days difference.&nbsp; If the data are timestamps, you might need to cast as date before subtracting.</P></BODY></HTML> Mon, 15 Dec 2014 18:45:31 GMT https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150888#M2574 DBailey 2014-12-15T18:45:31Z Re: How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150889#M2575 <HTML><HEAD></HEAD><BODY><P>Probably better off asking in a teradata forum? <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Mon, 15 Dec 2014 21:13:59 GMT https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150889#M2575 Reeza 2014-12-15T21:13:59Z Re: How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150890#M2576 <HTML><HEAD></HEAD><BODY><P>All database or quasi-database (ie Excel) systems store dates as numbers. Dates are typically stored as # of days from a given offset (1 Jan 1960 in SAS, 31 Dec 1899 in LibreOffice Calc/Excel), timestamps as # of seconds from the same offset.</P><P></P><P>So if you have real date values, simple subtracting will work, if you have timestamps, int(value1/86400) - int(value2/86400) will do the trick.</P></BODY></HTML> Tue, 16 Dec 2014 08:02:36 GMT https://communities.sas.com/t5/SAS-Data-Management/How-can-we-calculate-difference-in-days-of-two-dates-in-teradara/m-p/150890#M2576 Kurt_Bremser 2014-12-16T08:02:36Z