/SQL/Oracle last day of month

Oracle last day of month

Oracle first day of last year

-- Oracle: First day of previous year
SELECT trunc(add_months(sysdate, -12), 'YEAR') FROM DUAL;

4

Oracle last day of month

-- Last day of current month
SELECT trim(to_date(last_day(sysdate), 'DD/MM/YYYY')) AS LASTDAY FROM DUAL;

0

Similar codes

2 votes179 views1 answer
Mysql last 7 days including today
SQL
11 votes191 views2 answers
Oracle saurce code
SQL
11 votes188 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote187 views2 answers
How to install mssql on mac
SQL
-1 vote188 views4 answers
Restart mysql server ubuntu
SQL
8 votes204 views2 answers
How to fetch data from database without last column
SQL
0 vote140 views2 answers
Postgresql could not start server mac
SQL
0 vote204 views1 answer
Sql sort ages
SQL
0 vote172 views2 answers
Find Overlapping sql
SQL
3 votes177 views4 answers
Show sql server database
SQL

Share