/SQL/Oracle first day of last year

Oracle first day of last year

Oracle first day of last year

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

4

Oracle sql first day of year

-- Oracle: First day of year
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;

1

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

6 votes270 views2 answers
Mysql check auto increment value
SQL
2 votes279 views1 answer
Codeigniter print last sql query
SQL
0 vote270 views1 answer
RowDataPacket
SQL
0 vote269 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote279 views1 answer
Sql first
SQL
0 vote280 views1 answer
Oracle step procedure
SQL
0 vote326 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote306 views1 answer
How to create notes in mysql
SQL
3 votes270 views2 answers
Oracle synonym
SQL
1 vote260 views2 answers
Mysql update table from another table
SQL

Share