You can use curdate() function to get today’s date and then use year() function on it to get the current year.
select *
from YourTable
where year(YourColumn) = year(getdate())
and datepart(dy, YourColumn) <= datepart(dy, getdate())
SELECT current_date;
SELECT current_time;
SELECT current_date + current_time;
SELECT current_timestamp;
select YEAR(GETDATE())AS current_year;
select datepart(yyyy,getdate())AS current_year;
select datepart(MM,getdate()) AS current_month;
select datepart(dd,getdate()) AS current_day;
SELECT
DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS JoinOfYEAR,
DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS LastOfYEAR
The exact syntax to extract a year from a date in SQL depends on the specific SQL database you are using. Here are some examples for common SQL databases:
MySQL:
SELECT YEAR(date_column) FROM table_name;
PostgreSQL:
SELECT extract(year from date_column) FROM table_name;
SQL Server:
SELECT YEAR(date_column) FROM table_name;
Oracle:
SELECT EXTRACT(YEAR FROM date_column) FROM table_name;
In these examples, date_column is the name of the column that contains the date, and table_name is the name of the table that contains the date column. The YEAR or extract(year from …) function is used to extract the year from the date.
I hope you get an idea about sql get current year.