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

2 votes197 views2 answers
Checking data type in sql server
SQL
3 votes188 views1 answer
Select count from table mysql
SQL
0 vote178 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote213 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote186 views1 answer
Mysql create table like
SQL
6 votes220 views2 answers
Insert into select mysql
SQL
23 votes247 views2 answers
Query to delete a database in mysql
SQL
0 vote214 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
4 votes247 views3 answers
Postgres drop all tables
SQL
1 vote205 views1 answer
Lpad function in sql oracle
SQL