Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how define datepart(yyyy, ... ) for 10 year semester

Status
Not open for further replies.

fuadhamidov

Programmer
Sep 22, 2003
98
TR
hi
i need to get data by using order by clause. i use datapart( yyyy, .... ). it gives year. it is OK , but i need ten year semester. for example i want to group peaple for their born year :
1993 - 2002
1983 - 1992 etc.
is there any easy way in ms sql.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top