/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 vote152 views1 answer
Top frequency in sql server
SQL
27 votes173 views6 answers
Set password mysql
SQL
12 votes150 views4 answers
Import mysql database command line linux
SQL
0 vote153 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote159 views1 answer
Linked server delete openquery
SQL
5 votes161 views1 answer
Oracle get foreign keys on table
SQL
1 vote148 views1 answer
Sql only five first row
SQL
4 votes149 views2 answers
Postgres update single column
SQL
-1 vote112 views1 answer
Mysql how to set update or create
SQL
0 vote169 views1 answer
How to access to mysql without root
SQL

Share