/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

0 vote338 views1 answer
Print mysql
SQL
0 vote310 views1 answer
Show all mongodb
SQL
0 vote319 views1 answer
Can we rollback deleted data in sql
SQL
0 vote337 views1 answer
Sql find all different values in column
SQL
1 vote327 views1 answer
Sql try catch
SQL
28 votes306 views4 answers
Mysql delete database
SQL
2 votes357 views1 answer
Oracle block
SQL
0 vote334 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote414 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote425 views1 answer
How to show current database in mysql
SQL

Share