Oracle sql first day of quarter

Oracle sql first day of month

-- First day of month
SELECT TRUNC(sysdate, 'MONTH') from dual;

Oracle sql first day of year

-- Oracle: First day of year
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;

Oracle sql first day of 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 vote274 views1 answer
Alternative for LIMIT sql
SQL
2 votes254 views1 answer
Search query in mysql
SQL
3 votes238 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote244 views1 answer
Sql put two columns into one
SQL
0 vote265 views1 answer
Postgre query date
SQL
0 vote199 views1 answer
Mysql timeout 30 seconds
SQL
-1 vote234 views3 answers
Psql get last rows
SQL
0 vote250 views1 answer
Sql decimal to 2 places
SQL
1 vote248 views1 answer
OstgreSQL version
SQL
0 vote236 views1 answer
Convert int to varchar sql
SQL