How can we calculate difference in days of two dates in teradara? Note- we cannot use intck function in teradata
I think you can subtract dates in Teradata to get # days difference. If the data are timestamps, you might need to cast as date before subtracting.
Probably better off asking in a teradata forum?
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.