Sql first day of current year

SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0);			-- SQL Server
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;					-- Oracle
SELECT MAKEDATE(year(now()), 1);							-- MySQL

Similar codes

0 vote130 views1 answer
Mysql add comment to column
SQL
0 vote146 views1 answer
Custom row number
SQL
0 vote172 views1 answer
Get first monday of month sql
SQL
19 votes149 views5 answers
Display table in sql
SQL
0 vote88 views1 answer
Mysql convert column to uppercase
SQL
0 vote145 views1 answer
Mysql sum per week
SQL
0 vote131 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote143 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote127 views1 answer
Sqlite to csv statement
SQL
0 vote143 views2 answers
Sql query for getting details by id
SQL