Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle first and last day of previous month

select add_months(trunc(sysdate,'mm'),-1), last_day(add_months(trunc(sysdate,'mm'),-1)) from dual 
 
PREVIOUS NEXT
Tagged: #oracle #day #previous #month
ADD COMMENT
Topic
Name
1+6 =