Tags for DateDiff
DateAdd and DateDiff function in Teradata??
On SQL Server you can do something like DateAdd(ms, DateDiff(ms, date1, date2), date1)/2 To get the mid date between two date 2016-02-03 12:00:00 and 2016-02-03 14:00:00, you should get the result 2016-02-03 13:00:00. How do you do that in Teradata when you have two timestamp(6) values? Peter Schwennesen
DateAdd DateDiff TIMESAMP(6)
Datediff to date
I am trying to go from this: and (a.ActlShpmtStrtDt >= "to_date"('01/07/2014', 'dd/mm/yyyy') to this and (a.ActlShpmtStrtDt >= "to_date"(w,currentdate,-13)   thank you for any help
DateDiff
New to Teradata from T-SQL
Good Morning All, I've just changed roles. I've got about 4 years experience with MS SQL Server (T-SQL) and my new role uses Teradata.
TSQL DECLARE DateDiff date REFERENCE variables
Creating a table
Hi all, PLZ look into this queryCreate table ptemp.ateds as ( select a.ACCT_I,a.Open_D, a.Clse_D, year(a.clse_d) - year(a.open_d) as dte from pvdata.acct_base as a having a.open_d != null and year(a.Open_D) != 1111 and a.ACCT_I like '%SAV%' order by a.open_d desc) with data
create table year DateDiff