DATEPART QUARTER从SQL转换为LINQ [英] DATEPART QUARTER conversion to LINQ from SQL

问题描述

如何将此SQL语句转换为LINQ？

How to convert this SQL statement to LINQ ?

DATEPART(QUARTER,getDate())

推荐答案

我有一个解决方案。但这很冗长。任何简单的方法？

I have got a solution. But this is lengthy.Any simple method?

int month = DateTime.Now.Month;
int Cur_Quarter = ((1<= month && month <=3 )?1:( (4<= month && month <=6 )?2 : ((7<= month && month <=9 ) ? 3 :((10<= month && month <=12 )?4:0) )));

请参阅以下代码：

Please see below code :

int month = DateTime.Now.Month;
int Cur_Quarter = ((month - 1) / 3) + 1;

这篇关于DATEPART QUARTER从SQL转换为LINQ的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！