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

0 vote443 views1 answer
How to subquey to do not load in live database in
SQL
1 vote352 views1 answer
Sql where last 12 months
SQL
0 vote321 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote341 views1 answer
Postgres select as csv
SQL
0 vote334 views1 answer
Nth max in my sql
SQL
0 vote344 views1 answer
Nosql vs sql
SQL
5 votes346 views1 answer
How to use rank function in sql
SQL
9 votes362 views2 answers
Sql server check table exists
SQL
1 vote377 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote330 views1 answer
Phpmyadmin mysql conflict
SQL