yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
select_registration_modification_dl(registration_id bigint)
Parameters
Name
Type
Mode
registration_id
bigint
IN
Definition
BEGIN RETURN (SELECT ed.exam_date + interval '8 h' FROM registration r INNER JOIN exam_session es ON r.exam_session_id = es.id INNER JOIN exam_date ed ON es.exam_date_id = ed.id WHERE r.id=registration_id) AT TIME ZONE 'Europe/Helsinki'; END;