NexusDB

Return the interval between two dates.

create function GetDateTimeInterval
(
  dt1 timestamp,
  dt2 timestamp,
  /*
  1: YEAR
  2: MONTH
  3: DAY
  4: HOUR
  5: MINUTE
  6: SECOND
  */
  interval_type smallint
  )
returns bigint
begin
  return
  case interval_type
    when 1 then (cast(dt1 as extended)-cast(dt2 as extended))/365.25+0.0025
    when 2 then ((cast(dt1 as extended)-cast(dt2 as
    extended))/365.25+0.0025)*12
    when 3 then cast(dt1 as extended)-cast(dt2 as extended)
    when 4 then (cast(dt1 as extended)-cast(dt2 as extended))*24
    when 5 then (cast(dt1 as extended)-cast(dt2 as extended))*1440
    when 6 then (cast(dt1 as extended)-cast(dt2 as extended))*86400
  end;
end;