public static DateTime? ToNullableDateTime(OracleTimeStampTZ value)
{
if (value.IsNull)
return null;
if (value.TimeZone == "UTC" || value.TimeZone == "+00:00")
return DateTime.SpecifyKind(value.Value, DateTimeKind.Utc);
var utc = value.Value.Subtract(value.GetTimeZoneOffset());
return DateTime.SpecifyKind(utc, DateTimeKind.Utc).ToLocalTime();
}
public static DateTime?ToNullableDateTime(OracleTimeStampTZ value)
{
if (value.IsNull)
{
return(null);
}
if (value.TimeZone == "UTC" || value.TimeZone == "+00:00")
{
return(DateTime.SpecifyKind(value.Value, DateTimeKind.Utc));
}
var utc = value.Value.Subtract(value.GetTimeZoneOffset());
return(DateTime.SpecifyKind(utc, DateTimeKind.Utc).ToLocalTime());
}
public static DateTimeOffset ToDateTimeOffset(this OracleTimeStampTZ value)
{
return(new DateTimeOffset(value.Value, value.GetTimeZoneOffset()));
}
