Anybody has this function so that I can use it in my report to fetch finish date in 13.3 version in Clarity.
Please share it if possible, this will really help to complete our report. We will really appreciate it.
Here you go
create or replace
p_date_in IN DATE
-- This function returns the Datetime in the format
-- 2001-12-05 00:00:00.000 and also does the finish date calculation
-- It drops the time portion.
IF p_date_in IS NULL THEN
IF TO_CHAR(p_date_in,'HH:MI:SS AM') = '12:00:00 AM' THEN
v_date_out := TRUNC(p_date_in - 1);
v_date_out := TRUNC(p_date_in);
Its a great help.
You welcome sir, have a great day.
Retrieving data ...