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))); }