Sql first day 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

14 votes113 views3 answers
Delete all records from table except sql
SQL
0 vote116 views1 answer
Mysql workbench view
SQL
0 vote120 views1 answer
How to start my sql server on mac
SQL
0 vote116 views1 answer
Sql revert migration
SQL
10 votes136 views2 answers
Select nextval from sequence oracle
SQL
1 vote67 views1 answer
Oracle character set
SQL
1 vote196 views3 answers
Showing all columns in an sqlite table
SQL
7 votes126 views1 answer
Query delete duplicates
SQL
0 vote110 views1 answer
Compare two tables to find unmatched records
SQL
27 votes235 views3 answers
Mysql delete row
SQL