0 - 4 of 4 tags for DateDiff

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

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

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.

Hi all,
PLZ look into this query
Create 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