/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 vote243 views1 answer
Sql get month from date
SQL
3 votes245 views2 answers
Sql end of month
SQL
1 vote251 views2 answers
Maximum number of tables in mysql
SQL
0 vote226 views1 answer
Drop domain postgresql
SQL
0 vote228 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote251 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote230 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote218 views1 answer
Postgresql parse json array
SQL
0 vote267 views1 answer
How to pass list as parameter in SQL query
SQL
-1 vote222 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL

Share