public static SqlExpression DateTimeDayOfWeek(SqlExpression _this)
{
var baseExpression = ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.DayOfWeek, _this));
var context = ExpressionTranslationContext.Current;
if (context == null)
{
return(baseExpression);
}
if (context.ProviderInfo.ProviderName == WellKnown.Provider.MySql)
{
return(baseExpression - 1); //Mysql starts days of week from 1 unlike in .Net.
}
return(baseExpression);
}
public static SqlExpression ToInteger([Type(typeof(string))] SqlExpression stringExpression)
{
return(ExpressionTranslationHelpers.ToInt(stringExpression));
}
public static SqlExpression DateTimeDayOfYear(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.DayOfYear, _this)));
}
public static SqlExpression DateTimeMillisecond(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Millisecond, _this)));
}
public static SqlExpression TimeSpanDays(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Day, _this)));
}
public static SqlExpression GenericSign(SqlExpression target)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(target)));
}
public static SqlExpression TimeSpanMilliseconds(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Millisecond, _this)));
}
public static SqlExpression DateTimeOffsetDayOfWeek(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.DayOfWeek, _this)));
}
public static SqlExpression DateTimeOffsetMinute(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.Minute, _this)));
}
public static SqlExpression Second(SqlExpression dateExpression)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Second, dateExpression)));
}
public static SqlExpression DecimalCompare(
[Type(typeof(decimal))] SqlExpression d1,
[Type(typeof(decimal))] SqlExpression d2)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(d1 - d2)));
}
