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

6 votes99 views3 answers
Update with inner join postgres
SQL
1 vote108 views1 answer
Mysql select from outside
SQL
0 vote104 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote103 views1 answer
Como saber si tengo mysql instalado
SQL
10 votes90 views3 answers
Join multiple tables sql
SQL
1 vote94 views1 answer
How refresh navicat tables to see new tables
SQL
5 votes126 views6 answers
Sql foreign key
SQL
59 votes271 views6 answers
Alter table sql
SQL
1 vote59 views1 answer
Mysql collation
SQL
0 vote132 views1 answer
Php insert null mysql
SQL