eBiss 3

Hilfe & Dokumentation

User Tools

Site Tools


en:transformation:mappings:funktionen:datum:datediff

Table of Contents

DateDiff

The DateDiff function (<DateTime>, <DateTime>, <String>) returns the difference between two DateTimes as a number and rounds, if need to, to 2 decimal digits. The returned value is always positive. Possible values ​​for the “identifier” parameter are:

  • s: For difference in seconds
  • min: For difference in minutes
  • h: For difference in hours
  • d: For difference in days
  • m: For difference in months
  • y: For difference in years

Syntax:

DateDiff(Date, Date, Identifier)

Samples:

DateDiff('1970-01-01', ActualDateTime(),'s')
Output in Unix format, in seconds since 1970
DateDiff('2017-01-01T06:00:00','2017-01-02T05:00:00','h')
return value: 23 (Hours)
DateDiff('2017-01-01','2017-01-20','d')
return value: 19 (Days)
DateDiff('2017-01-01','2017-05-01','m')
return value: 4 (Months)
DateDiff('2017-01-01','2026-07-01','y')
return value: 9 (Years)
en/transformation/mappings/funktionen/datum/datediff.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1