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

7 votes217 views1 answer
Minecraft forge server host
SQL
5 votes224 views3 answers
MySql get fields of table
SQL
2 votes220 views2 answers
How to add not null constraint in sql
SQL
0 vote217 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote210 views1 answer
Get records in sql according to month name and count
SQL
1 vote224 views1 answer
OstgreSQL version
SQL
-3 votes287 views8 answers
Sql to c# linq converter online
SQL
3 votes224 views2 answers
Mysql user permission database
SQL
2 votes230 views1 answer
Postgresql create table as select
SQL
1 vote207 views2 answers
Mysql does sentance contain word
SQL