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 vote137 views1 answer
Components/Fields of Internal Table
SQL
5 votes147 views1 answer
Get table columns from sql
SQL
1 vote140 views1 answer
Oracle create as select
SQL
1 vote137 views2 answers
Extract weekday from date in sql
SQL
0 vote146 views1 answer
Learnxinyminutes sql
SQL
-1 vote153 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote174 views1 answer
Doctors appointment
SQL
3 votes270 views6 answers
Sql unique select
SQL
16 votes135 views2 answers
Mysql date between two dates
SQL
10 votes127 views4 answers
Join with multiple conditions sql
SQL