jamespaultg · September 11, 2018 13:53
diff --git a/oracle_date_manipulations.sql b/oracle_date_manipulations.sql
 --Get the last date of the previous year (31-Dec-yyyy)
 select trunc(current_date, 'yyyy')-1 from dual;

 -- Get the first date of the previous year (01-Jan-yyyy)
 select add_months(trunc(current_date, 'yyyy'),-12) from dual;
	--Get the last date of the previous year (31-Dec-yyyy)
	select trunc(current_date, 'yyyy')-1 from dual;

	-- Get the first date of the previous year (01-Jan-yyyy)
	select add_months(trunc(current_date, 'yyyy'),-12) from dual;
No results found