shan

shan

  • NA
  • 1
  • 0

Month name in LINQ

Jun 2 2011 8:11 AM
Hi,

 I need month name in LINQ,

 The below query is used in SQL -

select CONVERT(VARCHAR(3), datename(MM, getdate()), 100)
to get the month name .

How to convert in LINQ.


I also need Week number of the month in LINQ

select datediff(week, convert(varchar(6), getdate(), 112) + '01', getdate()) + 1     AS Week


Answers (2)