/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 vote198 views1 answer
Update and replace mysql
SQL
0 vote196 views2 answers
Find Overlapping sql
SQL
0 vote197 views1 answer
Unique index in mysql
SQL
0 vote202 views1 answer
Merge clause with inner join
SQL
0 vote221 views1 answer
Postgresql find biggest table
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote216 views1 answer
How to get data from 2 database
SQL
0 vote191 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote218 views1 answer
Mysql last friday of current month
SQL
11 votes195 views1 answer
How to get ddl for materialized view
SQL

Share