public static string DatePart(string columnName, DatePartType partType)
{
StringBuilder sb = new StringBuilder("DATEPART(");
sb.Append(partType.ToString());
sb.Append(',');
SqlQueryUtils.AppendColumnName(sb, columnName);
sb.Append(')');
return(sb.ToString());
}
public static string DatePart(string columnName, DatePartType partType)
{
Check.Require(!string.IsNullOrEmpty(columnName), "columnName could not be null or empty!");
StringBuilder sb = new StringBuilder("DATEPART(");
sb.Append(partType.ToString());
sb.Append(',');
SqlQueryUtils.AppendColumnName(sb, columnName);
sb.Append(')');
return sb.ToString();
}
public static string DatePart(string columnName, DatePartType partType)
{
Check.Require(!string.IsNullOrEmpty(columnName), "columnName could not be null or empty!");
StringBuilder sb = new StringBuilder("DATEPART(");
sb.Append(partType.ToString());
sb.Append(',');
SqlQueryUtils.AppendColumnName(sb, columnName);
sb.Append(')');
return(sb.ToString());
}
public void Render(ISqlBuilder visitor, params Expression[] args)
{
if (args.Length != 2)
{
throw new ArgumentException(string.Format(Res.ArgumentCountError, "dateadd", "", "2"));
}
var addPart = (args[1] as ConstantExpression).Value;
visitor.Append("(");
visitor.Visit(args[0]);
visitor.Append(" + interval '" + addPart.ToString() + "' " + Type.ToString() + ")");
}
