/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

2 votes214 views2 answers
Mysql show table column comments sql
SQL
6 votes263 views1 answer
How to count number of rows in sql
SQL
0 vote180 views1 answer
Set column width in sqlplus
SQL
0 vote183 views1 answer
Stored procedure function relation
SQL
0 vote203 views1 answer
SQL server datetime compare
SQL
0 vote291 views1 answer
Mysql failed to login as root@localhost
SQL
10 votes274 views4 answers
Sql server pagination
SQL
0 vote275 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote181 views1 answer
Mysql view command
SQL
0 vote182 views1 answer
Subquery aggregation
SQL

Share