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 vote211 views1 answer
Postpresql relation not found
SQL
0 vote205 views1 answer
Addition of 2 column value in mysql
SQL
0 vote243 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote208 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote310 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote208 views1 answer
Show size of all tables postgres
SQL
0 vote200 views1 answer
Mysql two joins
SQL
1 vote424 views1 answer
How to make a select in sql
SQL
0 vote215 views1 answer
Compare field sql server
SQL
0 vote201 views1 answer
Is not null postgresql
SQL