pt_regular_multi_to_multi

Name and Parameters

pt_regular_multi_to_multi( PostTIME ) : PostTIME

Description

This function transform's an RegularMultiObject into a normal MultiObject, what means you get concrete instants.

Examples

SELECT pt_regular_multi_to_multi('R3/2012-1-1/P3M/P9M');
-- result  
'CAL0012012-01-01T00:00:00.000Z/2012-04-01T00:00:00.000Z,
2013-01-01T00:00:00.000Z/2013-04-01T00:00:00.000Z,
2014-01-01T00:00:00.000Z/2014-04-01T00:00:00.000Z,
2015-01-01T00:00:00.000Z/2015-04-01T00:00:00.000Z'

SELECT pt_regular_multi_to_multi('R3/2012-1-1/P30D');
-- result
'CAL0012012-01-01T00:00:00.000Z,2012-01-31T00:00:00.000Z,
2012-03-01T00:00:00.000Z,2012-03-31T00:00:00.000Z'

SELECT pt_regular_multi_to_multi('TCS002R2/21224211/P3123321');
-- result
'TCS00221224211.000000,210891107532.000000,421760990853.000000'

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

---

List of SQL Functions