58.71 GET_SINCE Function Signature 2
This function returns the relative date in words (for example, 2 days from now, 30 minutes ago). It also accepts a second optional p_short
parameter and returns "in 2d" or "30m" and so forth. This function is equivalent to using the format masks SINCE
and SINCE_SHORT
available within Oracle APEX and is useful within SQL queries or PL/SQL routines.
Syntax
APEX_UTIL.GET_SINCE (
p_value in [ timestamp | timestamp with time zone | timestamp with local time zone ],
p_short in [ boolean default false | varchar2 default 'N' ] )
RETURN VARCHAR2;
Parameters
Parameter | Description |
---|---|
p_value |
The TIMESTAMP , TIMESTAMP WITH TIME ZONE , TIMESTAMP WITH LOCAL TIME ZONE you want to format.
|
p_short |
Boolean or Y/N to indicate whether to return a short version of relative date. |
Examples
This example returns the LAST_UPDATE
column with the normal formatting.
select application_id, application_name, apex_util.get_since( last_updated_on ) last_update
from apex_applications
order by application_id;
This example returns the LAST_UPDATE
column with the short formatting.
select application_id, application_name, apex_util.get_since( last_updated_on, p_short => 'Y' ) last_update
from apex_applications
order by application_id
Parent topic: APEX_UTIL