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

5 votes170 views2 answers
Oracle to_timestamp
SQL
0 vote189 views1 answer
WHERE not regex in SQL
SQL
0 vote175 views2 answers
Oracle create chain rule
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
2 votes191 views2 answers
Change mysql password from command line
SQL
0 vote186 views1 answer
Check if database exists sql
SQL
0 vote179 views1 answer
Odd record sql query
SQL
0 vote195 views1 answer
Setval postgres example table id
SQL
0 vote218 views1 answer
Stored function in sql
SQL
0 vote165 views1 answer
Java spring boot connect to sql server
SQL