日期函数 里面 按周查询怎么样实现

[pengxinglove]

sqlserver SQL是这样写的
and DATEPART (WW, FIQCDATE)=DATEPART(WW,'" + strFromTime + "') and DATEPART (YEAR,FIQCDATE)=DATEPART (YEAR,'" + strFromTime + "')

[2881099]

https://github.com/dotnetcore/FreeSql/wiki/%e8%a1%a8%e8%be%be%e5%bc%8f%e5%87%bd%e6%95%b0#%E8%87%AA%E5%AE%9A%E4%B9%89%E8%A7%A3%E6%9E%90

自定义解析

[ExpressionCall]
public static class Sql {
  static ThreadLocal<ExpressionCallContext> context = new ThreadLocal<ExpressionCallContext>();
  public static DateTime FormatDateTime(this DateTime that, string arg1)
  {
    var up = context.Value;
    up.Result = $"date_format({up.ParsedContent["that"]}, {up.ParsedContent["arg1"]})";
    return that;
  }
}

var sql1 = fsql.Select<SysModule>().ToSql(a => a.CreateTime.FormatDateTime("yyyy-MM-dd"));
//SELECT date_format(a."CreateTime", 'yyyy-MM-dd') as1 
//FROM "SysModule" a

[pengxinglove]

好的，谢谢