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 vote321 views2 answers
Mysql row_number() example
SQL
2 votes271 views1 answer
Oracle current date without time
SQL
3 votes346 views2 answers
Sqlite show table structure
SQL
0 vote308 views1 answer
Mysql jdbc timezone
SQL
0 vote373 views1 answer
Why do we need data structure in sql
SQL
1 vote346 views1 answer
Login to database mysql terminal
SQL
0 vote437 views1 answer
Postgresql powershell query
SQL
7 votes327 views2 answers
Oracle sql drop index
SQL
9 votes303 views3 answers
Sequence postgresql
SQL
0 vote319 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL