48.70 GET_SINCE Function Signature 1

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_date  DATE )
   p_short IN [ BOOLEAN DEFAULT FALSE | VARCHAR2 DEFAULT 'N' ] )  
RETURN VARCHAR2;

Parameters

Table 48-60 GET_SINCE Parameters

Parameter	Description
p_date	The date you want formatted.
p_short	Boolean or Y/N to indicate whether to return a short version of relative date.

Example

select application_id, application_name,apex_util.get_since(last_updated_on) last_update 
    from apex_applications 
order by application_id