tm_distance_dec_day

Name and Parameters

tm_distance_dec_day( PostTIME , PostTIME ) : double precision

Description

This function calculates the distance between two primitive objects and returns the result in decimal days as double.

Examples

SELECT tm_distance_dec_day('2013-5-8T16:14:12.345','2013-5-9T22:21:20.191');
-- result
1.2549519212963

SELECT tm_distance_dec_day('2010-5-12T14:23:42','2010-4-12T14:23:42')
-- result
30

Processable Objects

| CAL | TCS | ORD ---|---|---|--- TM_Instant | ✔ | ✔ | ✗ TM_Period | ✔ | ✔ | ✗ MultiInstant | ∼ | ∼ | ✗ MultiPeriod | ∼ | ∼ | ✗ RegularMultiInstant | ∼ | ∼ | ✗ RegularMultiPerid | ∼ | ∼ | ✗ ✔ : Processable

✗ : Call will cause an error

∼ : Callable without error, but returns only a pseudo result

Related functions

tm_distance

---

List of SQL Functions