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 vote280 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote272 views1 answer
Sql DATE = GETDATE()
SQL
0 vote231 views0 answer
SQL
1 vote265 views1 answer
Sql find column name like
SQL
1 vote263 views1 answer
Operator does not exist: integer = text
SQL
8 votes305 views1 answer
Mysql dump restore
SQL
0 vote264 views1 answer
Postgres enumerated type
SQL
0 vote263 views2 answers
Return the number of records in a single table mysql
SQL
0 vote308 views1 answer
Sparql list all graphs
SQL
1 vote271 views1 answer
Hexadec to sql REDSHIFT
SQL