deepusurana
SSC Enthusiast
Points: 144
More actions
December 20, 2007 at 1:41 am
#70614
Hi,
I am accpting date from the user in a form.
And i want to display the data in crystal reports month wise, in which i want the month names to be the column.
Ex:
Is there any way by which i can achive this output by sql query...?:confused:
Chandra Sekhara Vyas Dhara
SSChampion
Points: 10207
December 20, 2007 at 1:50 am
#761673
Use datename function
For Example if you want to get current month
select datename(mm,getdate())
Gogula G. Aryalingam
SSCrazy
Points: 2688
December 20, 2007 at 2:14 am
#761675
http://www.sqlservercentral.com/Forums/Topic435101-149-1.aspx?Update=1
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply