/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 vote356 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote327 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
15 votes319 views3 answers
Find duplicate keys in mysql
SQL
0 vote323 views1 answer
Sql server bool select
SQL
0 vote354 views1 answer
Amount of entries in a table psql
SQL
0 vote322 views1 answer
Mysql join same table multiple times group by
SQL
2 votes327 views1 answer
Oracle apex list connected users
SQL
1 vote320 views1 answer
Get count by weekly pivot table sql server
SQL
1 vote276 views1 answer
Restart identity postgresql
SQL
0 vote331 views1 answer
Set root password mysql xampp
SQL

Share