authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_system_date
Description
Get system date from property’s database
Parameters
Name
Type
Mode
prop_id
integer
IN
Definition
select case prop_id when 1 then null else --(select param_value::date from fn_prop_params(prop_id, 'SYSTEM', 'SYSTEM_DATE')) ( select obj_params from dblink(fn_prop_connection($1), 'select fn_system_date()') as (obj_params date) ) end