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 vote175 views1 answer
Convert rows into columns in oracle
SQL
1 vote175 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote182 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote127 views1 answer
Jooq finding lastest value in table
SQL
1 vote173 views1 answer
Float precision in psql
SQL
27 votes171 views4 answers
Get all tables with column name sql
SQL
-1 vote162 views1 answer
MYSQL stored procedure select from
SQL
0 vote192 views1 answer
SQL SERVER xquery count child nodes
SQL
5 votes207 views2 answers
Functions
SQL
0 vote167 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL