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

11 votes271 views2 answers
Having clause
SQL
5 votes305 views3 answers
Postgres show databases
SQL
0 vote291 views1 answer
Sql list dates between two dates
SQL
1 vote276 views1 answer
Tsql random number
SQL
0 vote295 views1 answer
Sql menampilkan data tabel
SQL
0 vote273 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote285 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote274 views1 answer
Sql string length postgresql
SQL
12 votes288 views5 answers
Sql merge
SQL
4 votes297 views2 answers
Sql offset
SQL