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 vote338 views1 answer
Creation d'un trigger sql
SQL
0 vote350 views1 answer
Change role postgres
SQL
0 vote342 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote358 views1 answer
T-sql delete view if exists
SQL
1 vote355 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
9 votes327 views6 answers
Sql add column with default value
SQL
1 vote338 views1 answer
Postgresql escape single quote
SQL
0 vote346 views1 answer
How to make case insensitive in sql
SQL
0 vote377 views2 answers
Clauses in mysql
SQL
0 vote324 views1 answer
Cast for print sql
SQL