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 vote197 views1 answer
Guid string to binary better
SQL
31 votes189 views3 answers
Sql count
SQL
0 vote191 views1 answer
Tsql default value when no value returned by query
SQL
9 votes209 views5 answers
Sql delete duplicate rows but keep one
SQL
1 vote190 views3 answers
Default password of mysql
SQL
0 vote216 views2 answers
Dumping sql table
SQL
10 votes200 views5 answers
Mysql create user
SQL
2 votes213 views3 answers
Sql interview query questions
SQL
1 vote205 views1 answer
Oracle insert multiple rows into same table
SQL
2 votes143 views1 answer
Oracle current date without time
SQL