/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

1 vote298 views1 answer
Sql try catch
SQL
0 vote324 views1 answer
How to run mysql in git bash
SQL
0 vote324 views1 answer
How to retrive the today date sql
SQL
5 votes295 views4 answers
Sql check
SQL
17 votes293 views5 answers
Order by sql
SQL
6 votes323 views1 answer
Oracle rank
SQL
16 votes292 views3 answers
Order by sql query
SQL
0 vote300 views1 answer
Display first three characters sql
SQL
12 votes295 views1 answer
Docker run mysql image
SQL
-1 vote300 views1 answer
Add bool column in sql
SQL

Share