/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 vote125 views1 answer
Mysql current time
SQL
3 votes128 views1 answer
Mysql load sql from file
SQL
2 votes117 views1 answer
Oracle sql drop column if exists
SQL
0 vote135 views1 answer
Create database store
SQL
12 votes135 views1 answer
Script to add new column in table sql
SQL
2 votes114 views1 answer
Mysql auto increment jumping
SQL
0 vote144 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote121 views1 answer
Power bi find all ids not in other tables
SQL
0 vote151 views1 answer
What is default mysql database password in linux
SQL
0 vote139 views1 answer
Interview experience as a call?
SQL

Share