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

2 votes113 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote116 views1 answer
How to find table lock and row lock in mysql
SQL
1 vote99 views2 answers
Oracle replace
SQL
1 vote91 views1 answer
Mysql count all table rows
SQL
0 vote117 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote100 views1 answer
Soql more than today
SQL
25 votes95 views6 answers
Modify column name in mysql
SQL
0 vote161 views1 answer
How to rename a database in tsql
SQL
6 votes99 views2 answers
Psql load dump
SQL
0 vote103 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL