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 vote209 views1 answer
Pagination with row_number
SQL
0 vote192 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
8 votes207 views1 answer
Show mysql user table
SQL
27 votes211 views6 answers
Set password mysql
SQL
0 vote187 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote210 views1 answer
Incorrect string value: mysql
SQL
4 votes203 views3 answers
How to describe a table in sqlite3
SQL
1 vote194 views1 answer
Base nosql
SQL
1 vote232 views1 answer
Mysql print variable
SQL
0 vote228 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL