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

1 vote138 views1 answer
Autocommit mysql
SQL
0 vote146 views1 answer
Ubuntu connect to mssql database
SQL
18 votes149 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote128 views2 answers
How to check if sql query is correct online
SQL
0 vote170 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote115 views1 answer
Mysql case when on date
SQL
6 votes131 views2 answers
Drop foreign key
SQL
2 votes125 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote119 views1 answer
Update top 100 sql
SQL
0 vote133 views1 answer
Import excel to sql
SQL