Wednesday, 14 May 2008

using datename function for name of month,day

 


select DATENAME(w, GETDATE()) AS ' Day Name'

day name

---------
Wednesday

SELECT DATENAME(m, GETDATE()) AS ' month Name'

month name

---------

may

 

 

 

Share:

0 Comments:

Post a Comment