db.migration.V33__fix_AQL_time_retrieval.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of base Show documentation

There is a newer version: 0.32.0

-- ensures that date/time handling is the same for time with or without timezone
CREATE OR REPLACE FUNCTION ehr.js_dv_date_time(datetime TIMESTAMP, timezone TEXT)
    RETURNS JSON AS
$$
BEGIN
    RETURN ehr.js_dv_date_time(datetime::TIMESTAMPTZ, timezone);
END
$$
LANGUAGE plpgsql;