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

3 votes359 views1 answer
MySQL DELETE JOIN
SQL
0 vote349 views1 answer
Except in sql
SQL
1 vote349 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote387 views1 answer
Query builder doctrien return sql
SQL
14 votes374 views1 answer
Oracle new column
SQL
0 vote346 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote358 views1 answer
Table or view does not exist
SQL
9 votes355 views5 answers
Sql limit
SQL
0 vote360 views1 answer
Postgres create extension if not exists
SQL
2 votes361 views2 answers
Sql strip non alphanumeric characters
SQL