Home › SQL Server › SQL Server DATE calculations

SQL Server - To get currentyear from system time


To get currentyear from system time 

select year(CURRENT_TIMESTAMP);

Using getdate()

select year(getdate())

Using datepart

Select datepart(year,getdate())

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.