aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_endday_increment_system_date
Parameters
Name
Type
Mode
user_name
text
IN
status
text
INOUT
msg
text
INOUT
Definition
BEGIN PERFORM sp_set_param('SYSTEM','SYSTEM_DATE', fn_system_date()+1); UPDATE registration r SET room_posted = true WHERE r.status = 'I'; PERFORM sp_reset_roomavail(); status = 'success'; msg = 'System date changed to ' || to_char(fn_system_date(), 'DD-MM-YYYY'); END