Tuesday 11 March 2014

Get Day of Week in SQL 2005/2008

select  DATENAME(dw,comtype) AS OrderDay from tblcom_type where s_no=6
   --Result  Friday

No comments:

Post a Comment

Followers