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 vote297 views1 answer
Sql search all columns of database oracle sql
SQL
10 votes287 views3 answers
Sql limit results
SQL
0 vote306 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote315 views1 answer
Create bdd mysql
SQL
9 votes302 views6 answers
Sql add column with default value
SQL
6 votes298 views1 answer
Oracle desc table primary key
SQL
0 vote318 views2 answers
Greater than sql server
SQL
1 vote314 views1 answer
Mysql query where in select
SQL
0 vote327 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote299 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL