GET_SINCE Function Date Formatting like ago

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

GET_SINCE Function Date Formatting like ago

Post by admin »

APEX_UTIL.GET_SINCE (
p_date DATE )
p_short IN [ BOOLEAN DEFAULT FALSE | VARCHAR2 DEFAULT 'N' ] )
RETURN VARCHAR2;

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

Sample output,
format.jpg
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest