public OracleTimestampWithLocalTimeZone(OracleTimeStampLTZ timeStamp) { _value = timeStamp; if (!timeStamp.IsNull) { _dateTime = new OracleDateTime(timeStamp.Year, timeStamp.Month, timeStamp.Day, timeStamp.Hour, timeStamp.Minute, timeStamp.Second); } }
public void TestDateMode() { var aggregator = new OracleValueAggregator(); var date = new OracleDateTime(new OracleDate(2016, 6, 22)); aggregator.AddValue(date); aggregator.AddValue(date); aggregator.Mode.Value.ShouldBe(date); aggregator.Mode.Count.ShouldBe(2); }
public static OracleBoolean NotEquals(OracleDateTime x, OracleDateTime y) {}
public static OracleBoolean LessThan(OracleDateTime x, OracleDateTime y) {}
public static OracleBoolean GreaterThan(OracleDateTime x, OracleDateTime y) {}
public OracleDateTime(OracleDateTime from) {}
protected bool Equals(OracleDateTime other) { return(Equals(RawValue, other.RawValue)); }
public static OracleBoolean op_LessThanOrEqual(OracleDateTime x, OracleDateTime y) {}
public static OracleBoolean op_Equality(OracleDateTime x, OracleDateTime y) { }
public static System.DateTime op_Explicit(OracleDateTime x) { }
public static OracleBoolean NotEquals(OracleDateTime x, OracleDateTime y) { }
public static OracleBoolean LessThanOrEqual(OracleDateTime x, OracleDateTime y) { }
public static OracleBoolean GreaterThanOrEqual(OracleDateTime x, OracleDateTime y) { }
public OracleDateTime(OracleDateTime from) { }
public static OracleBoolean op_LessThan(OracleDateTime x, OracleDateTime y) { }
public static System.DateTime op_Explicit(OracleDateTime x) {}
public static OracleBoolean op_GreaterThanOrEqual(OracleDateTime x, OracleDateTime y) {}
public static OracleBoolean op_GreaterThan(OracleDateTime x, OracleDateTime y) { }
public static OracleBoolean op_Inequality(OracleDateTime x, OracleDateTime y) {}
internal static string FormatValue(OracleDateTime dateTime, int nanoseconds, int fractionPrecision) { var fractionPart = nanoseconds.ToString(CultureInfo.InvariantCulture).PadLeft(9, '0').Substring(0, fractionPrecision); return($"{dateTime}{(String.IsNullOrEmpty(fractionPart) ? null : $".{fractionPart}")}");
public void AddValue(object value) { if (value == null || value == DBNull.Value) { return; } if (value is IValue oracleValue && oracleValue.IsNull) { return; } Type valueType; var oracleNumber = value as OracleNumber; if (value is int || value is long || value is decimal || value is short || value is uint || value is ulong || value is ushort) { value = oracleNumber = new OracleNumber(new OracleDecimal(Convert.ToDecimal(value))); } var oracleDate = value as OracleDateTime; if (value is DateTime) { value = oracleDate = new OracleDateTime(new OracleDate(Convert.ToDateTime(value))); } Count++; _distinctValues.Add(value); var oracleTimestamp = value as OracleTimestamp; var oracleTimestampTimezone = value as OracleTimestampWithTimeZone; var oracleTimestampLocalTimezone = value as OracleTimestampWithLocalTimeZone; var oracleIntervalYearToMonth = value as OracleIntervalYearToMonth; var oracleIntervalDayToSecond = value as OracleIntervalDayToSecond; if (oracleNumber != null) { valueType = typeof(OracleDecimal); var typedValue = (OracleDecimal)oracleNumber.RawValue; _oracleNumberSum += typedValue; } else if (oracleDate != null) { valueType = typeof(OracleDate); AggregatedValuesAvailable = false; } else if (oracleTimestamp != null) { valueType = typeof(OracleTimeStamp); AggregatedValuesAvailable = false; } else if (oracleTimestampTimezone != null) { valueType = typeof(OracleTimeStampTZ); AggregatedValuesAvailable = false; } else if (oracleTimestampLocalTimezone != null) { valueType = typeof(OracleTimeStampLTZ); AggregatedValuesAvailable = false; } else if (oracleIntervalYearToMonth != null) { valueType = typeof(OracleIntervalYM); var typedValue = (OracleIntervalYM)oracleIntervalYearToMonth.RawValue; _oracleYearToMonthSum += typedValue; } else if (oracleIntervalDayToSecond != null) { valueType = typeof(OracleIntervalDS); var typedValue = (OracleIntervalDS)oracleIntervalDayToSecond.RawValue; _oracleDayToSecondSum += typedValue; } else { valueType = typeof(object); AggregatedValuesAvailable = false; LimitValuesAvailable = false; } if (LimitValuesAvailable) { _typeValues.Add(Tuple.Create(valueType, value)); } if (_valueType == null) { _valueType = valueType; } else if (_valueType != valueType) { SetIndeterminate(); } }
public void AddValue(object value) { if (value == null || value == DBNull.Value) { return; } var oracleValue = value as IValue; if (oracleValue != null && oracleValue.IsNull) { return; } Type valueType; var oracleNumber = value as OracleNumber; if (value is int || value is long || value is decimal || value is short || value is uint || value is ulong || value is ushort) { value = oracleNumber = new OracleNumber(new OracleDecimal(Convert.ToDecimal(value))); } var oracleDate = value as OracleDateTime; if (value is DateTime) { value = oracleDate = new OracleDateTime(new OracleDate(Convert.ToDateTime(value))); } Count++; _distinctValues.Add(value); var oracleTimestamp = value as OracleTimestamp; var oracleTimestampTimezone = value as OracleTimestampWithTimeZone; var oracleTimestampLocalTimezone = value as OracleTimestampWithLocalTimeZone; var oracleIntervalYearToMonth = value as OracleIntervalYearToMonth; var oracleIntervalDayToSecond = value as OracleIntervalDayToSecond; if (oracleNumber != null) { valueType = typeof(OracleDecimal); var typedValue = (OracleDecimal)oracleNumber.RawValue; _oracleNumberSum += typedValue; } else if (oracleDate != null) { valueType = typeof(OracleDate); AggregatedValuesAvailable = false; } else if (oracleTimestamp != null) { valueType = typeof(OracleTimeStamp); AggregatedValuesAvailable = false; } else if (oracleTimestampTimezone != null) { valueType = typeof(OracleTimeStampTZ); AggregatedValuesAvailable = false; } else if (oracleTimestampLocalTimezone != null) { valueType = typeof(OracleTimeStampLTZ); AggregatedValuesAvailable = false; } else if (oracleIntervalYearToMonth != null) { valueType = typeof(OracleIntervalYM); var typedValue = (OracleIntervalYM)oracleIntervalYearToMonth.RawValue; _oracleYearToMonthSum += typedValue; } else if (oracleIntervalDayToSecond != null) { valueType = typeof(OracleIntervalDS); var typedValue = (OracleIntervalDS)oracleIntervalDayToSecond.RawValue; _oracleDayToSecondSum += typedValue; } else { valueType = typeof(object); AggregatedValuesAvailable = false; LimitValuesAvailable = false; } if (LimitValuesAvailable) { _typeValues.Add(Tuple.Create(valueType, value)); } if (_valueType == null) { _valueType = valueType; } else if (_valueType != valueType) { SetIndeterminate(); } }