/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

0 vote282 views1 answer
How to use lower case in mysql
SQL
0 vote255 views1 answer
Como leer datos de mysql esp32
SQL
2 votes314 views2 answers
Mysql does sentence contain word
SQL
0 vote269 views1 answer
Oracle last connection
SQL
0 vote294 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote309 views2 answers
How to count codition
SQL
0 vote270 views1 answer
Back up stored procedures mysql
SQL
-1 vote340 views1 answer
Difference berween database and data base management system
SQL
3 votes289 views1 answer
Pl sql escape &
SQL
0 vote282 views1 answer
Datagrip go to line
SQL

Share