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 vote198 views2 answers
Mysql cast to varchar
SQL
5 votes146 views1 answer
Oracle get foreign keys on table
SQL
1 vote206 views1 answer
Concat first name and last name in mysql
SQL
3 votes139 views2 answers
Mysql create timestamp column
SQL
24 votes144 views4 answers
Mssql get all table names
SQL
0 vote149 views2 answers
Greater than sql server
SQL
0 vote133 views1 answer
Online sql testing tool
SQL
0 vote137 views1 answer
Sql select duplicates based on two columns
SQL
1 vote166 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
1 vote98 views1 answer
Database run
SQL