pt_refsys_instance

Name and Parameters

pt_refsys_instance( PostTIME ) : integer

Description

Get the system-instance number of an posttime-instance's reference system as integer.

Examples

SELECT pt_refsys_instance('CAL0012013-12-24T12');
-- result
1

SELECT pt_refsys_instance('CAL0022013-12-24T12');
-- result
2

SELECT pt_refsys_instance('ORD001Triassic');
-- result
1

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

pt_type, pt_refsys_type

---

List of SQL Functions