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 vote193 views1 answer
Authentication modes in sql server
SQL
0 vote222 views1 answer
Linux upload database to mysql
SQL
0 vote147 views1 answer
How to find sql server installation folder
SQL
0 vote166 views1 answer
Python dictionary to sql update
SQL
7 votes170 views1 answer
Sql limit decimal places
SQL
5 votes166 views1 answer
Sql table columns
SQL
0 vote165 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote151 views1 answer
Can't connect to postgresql mac os
SQL
0 vote161 views2 answers
Change database postgres
SQL
11 votes243 views2 answers
Sql between date range
SQL