/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 votes209 views4 answers
2nd highest salary in mysql
SQL
0 vote196 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote190 views1 answer
Login failed for login due to trigger execution
SQL
0 vote210 views1 answer
Add mysql database to power bi web
SQL
7 votes178 views6 answers
Reset identity column in sql server
SQL
3 votes223 views2 answers
Synonym oracle
SQL
0 vote182 views1 answer
The local psql command could not be located
SQL
0 vote203 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote195 views1 answer
Min salary in sql
SQL
0 vote232 views1 answer
Implode in sql query
SQL

Share