tm_duration_dec_day

Name and Parameters

tm_duration_dec_day( PostTIME ) : double precision

Description

This function calculates the duration of one object and returns the result in decimal days as double.

Examples

SELECT tm_duration_dec_day('2013-5-30T8/2013-5-30T12:45');
-- result
0.197916666666667

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_duration

---

List of SQL Functions