/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 vote228 views1 answer
How to create a table in sql stack overflow
SQL
1 vote228 views1 answer
SQL date part only of datetime
SQL
1 vote220 views1 answer
Oracle index partition
SQL
8 votes226 views1 answer
Oracle add months to sysdate
SQL
-1 vote221 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote238 views1 answer
Query by column for substring sql
SQL
17 votes243 views6 answers
Change column name in sql
SQL
0 vote259 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote251 views1 answer
Full outer join in mariadb mysql
SQL
0 vote238 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL

Share