How can I get the year value from a date type in TSQL

0	I want to get the year (or month or day) portion from a TSQL (T-SQL) statement. How to do that? function date sql tsql timestamp asked Nov 09 '10 at 08:49 guru4us 1●6●23 edited Nov 09 '10 at 08:59

One Answer:

oldest newest most voted

There are various ways to do that:

You can use year(), month() or day() function.

select year(getdate()), month(getdate()), day(getdate())
Or you can use datename() function

select datename(yyyy,getdate())
Or even you can use more complex way like this

select substring(convert(varchar(20),getdate(),112),1,4) --year

answered Nov 09 '10 at 08:58

guru4us
1●6●23

Your answer

toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

GURU4us questions and answers community Platform

The unique difference between GURU4us and other Q & A websites is that even , you can make google adsense money via the GURU4us's platform. Go to your profile setting interface (click the right-upper menu item [username] and select "user tool -> adverstisement setting" to set your adsense codes, so that you can get adsense money from each question or answer you contribute. Detail can be found from FAQ

If you have questions, please read FAQ first.
You can directly use the GURU4us to ask our questions, put guru4us plus bug, feedback, problem, suggestion etc as tag, or you can ask questions, feedbacks, complains and suggest us from here

Furthermore, you can treat guru4us as your Q&A or FAQ collection, create your own questions and answers or FAQ database, to share and help others.

Tags:

sql ×5
tsql ×4
timestamp ×2
date ×1
function ×1

Asked: Nov 09 '10 at 08:49

Seen: 970 times

Last updated: Nov 09 '10 at 08:59

How can I get the year value from a date type in TSQL

Follow this question

GURU4us questions and answers community Platform

Learn more about GURU4us questions and answers community platform

Related questions