Oracle sql first day of quarter

Oracle sql first day of month

-- First day of month
SELECT TRUNC(sysdate, 'MONTH') from dual;

Oracle sql first day of year

-- Oracle: First day of year
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;

Oracle sql first day of quarter

-- trunc(date, format)						DUAL is for Oracle
SELECT trunc(sysdate, 'Q') FROM DUAL;       -- 1rst quarter day
SELECT trunc(sysdate) FROM DUAL;            -- today 00:00:00
SELECT trunc(sysdate, 'YEAR') FROM DUAL;    -- 1rst year day
SELECT trunc(sysdate, 'MONTH') FROM DUAL;   -- 1rst month day

Similar codes

0 vote298 views1 answer
Coalesce for comma separated in sql server
SQL
13 votes296 views2 answers
Sql join 3 tables
SQL
0 vote309 views1 answer
Postgresql stored procedure update table values
SQL
1 vote295 views1 answer
How to see which columns are indexxed mysql
SQL
2 votes289 views1 answer
How to show the whole table in sql
SQL
11 votes259 views1 answer
Reset identity sql server
SQL
0 vote318 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote295 views2 answers
Find nth highest salary of an employee
SQL
0 vote279 views1 answer
What is the use of index in mysql table
SQL
8 votes320 views2 answers
Between operator
SQL