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

1 vote294 views1 answer
Mysql month name extract
SQL
0 vote323 views1 answer
Mysql reset wp_options
SQL
3 votes306 views2 answers
Find string in stored procedure sql server
SQL
2 votes295 views2 answers
Mysql show table column comments sql
SQL
9 votes327 views3 answers
Where clause sql
SQL
1 vote310 views1 answer
Random name function in mysql for nvarchar
SQL
4 votes292 views2 answers
Postgresql reset sequence
SQL
0 vote285 views1 answer
Database timezone
SQL
0 vote274 views1 answer
Automate mysql cli query
SQL
0 vote291 views1 answer
How to create a table in sql stack overflow
SQL