Select only year from date field MSSql query

sql Share on :

To extract year from a date in the MSSql Server you can use the year() method of MSSql.

SELECT year(date_column) as my_year FROM table_name;

Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

In the above query, we have a table that has a date type column. When selecting this date type column we are only showing its date.

For example, If We have a table named Employee and it has a date type column Join_Date. To get the year from the Join_Date column we can use below MSSql Query.

SELECT 
   year(Join_Date) as join_year 
FROM 
   Employee;

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Remove all tables from database using MSSQL query
MSSQL query to insert value which contains apostrophe or single quote
Case Insensitive SQL Select Query with WHERE clause
SQL Server query to add auto increment field
Select statement
Insert data into table mysql query
Drop table SQL query