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

1 vote372 views1 answer
Postgres set column based on another column
SQL
0 vote345 views1 answer
Mysql update set sum
SQL
3 votes407 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote355 views1 answer
Oracle select first result
SQL
0 vote340 views1 answer
Ksql quickstart docker
SQL
0 vote350 views1 answer
Replace content value from old to new sql
SQL
0 vote349 views1 answer
Python sqlalchemy orm to select null values
SQL
1 vote337 views1 answer
Type int in mysql maxlenght
SQL
0 vote319 views1 answer
Store query result in variable sql
SQL
0 vote354 views1 answer
C# mysql update statement set value to null
SQL