pt_transform_system

Name and Parameters

pt_transform_system( PostTIME , text ) : PostTIME

Description

Transforms a PostTIME instance into the reference system specified by the given key.

Examples

-- UNIX time to gregorian calendar.
SELECT pt_transform_system('TCS0021', 'CAL001');
-- result
'CAL0011970-01-01T00:00:01.000Z'

 -- or calendar date to julian day
SELECT pt_transform_system('CAL0012013-4-30T12:20', 'TCS001');
-- result
'TCS0012456413.013889'

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