/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 vote216 views1 answer
Table information in sql server
SQL
1 vote229 views1 answer
SQL Integer devision
SQL
2 votes205 views1 answer
Sql server check for value in multiple columns
SQL
0 vote209 views5 answers
Sql table intermédiaire
SQL
3 votes352 views9 answers
Linq to sql converter online
SQL
0 vote237 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote202 views1 answer
How to count with except in psql
SQL
17 votes233 views3 answers
Postgresql list users
SQL
0 vote224 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote215 views1 answer
How many rows affected in sqllite
SQL

Share