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 votes333 views3 answers
Mysql unix timestamp to date
SQL
0 vote261 views1 answer
Mysqlimport
SQL
0 vote266 views1 answer
View to table
SQL
0 vote270 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote298 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote258 views2 answers
Plsql function that return a table
SQL
0 vote287 views1 answer
Create table database in psql
SQL
0 vote231 views1 answer
Mysql find foreign key references
SQL
0 vote303 views1 answer
Use mysql in java program
SQL
1 vote283 views1 answer
Where to locate set password for mysql
SQL