/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 vote273 views2 answers
What is the default password for sql server sa
SQL
1 vote306 views1 answer
Oracle drop temporary table
SQL
3 votes271 views1 answer
How to find names includes in sql
SQL
0 vote260 views3 answers
Average salary in sql
SQL
13 votes284 views3 answers
Change data type postgresql
SQL
0 vote276 views1 answer
Limit in access query
SQL
1 vote228 views1 answer
Foreign key in oracle sql developer
SQL
1 vote266 views2 answers
Sql multiline comment
SQL
0 vote278 views1 answer
Multiple replace value mssql
SQL
0 vote279 views1 answer
How to create a table based on another table in mysql
SQL

Share