DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
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
COMMENT
Name
4+3 =
Submit