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 vote124 views2 answers
Get table column names sql laravel
SQL
0 vote129 views1 answer
Mysql get date diff in months
SQL
0 vote110 views1 answer
Sql insert query list of dictionaries
SQL
13 votes118 views2 answers
Oracle inner join
SQL
9 votes109 views2 answers
Oracle all tables in schema
SQL
18 votes117 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote125 views1 answer
Mysql count with two joins
SQL
0 vote112 views3 answers
ChAnge TABLE name apex oracle
SQL
2 votes76 views1 answer
Sql float to int
SQL
0 vote118 views1 answer
Psql list rules
SQL