oracle定义日期列datetime,OracleDateTime

OracleDateTime 结构

定义

程序集:System.Data.OracleClient.dll

表示日期和时间数据，取值范围从公元前 4712 年 1 月 1 日 到公元 4712 年 12 月 31 日。Represents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD.

本文内容

public value class OracleDateTime : IComparable, System::Data::SqlTypes::INullable

public struct OracleDateTime : IComparable, System.Data.SqlTypes.INullable

type OracleDateTime = struct

interface INullable

Public Structure OracleDateTime

Implements IComparable, INullable

继承

注解

结构的最小有效日期 OracleDateTime 为 1/1/0001 00:00:00。The minimum valid date for an OracleDateTime structure is 1/1/0001 00:00:00. 但是，Oracle 支持早于4712年1月1日的日期。However, Oracle supports dates as early as January 1, 4712 BC. 若要绑定 BC 日期，请 String 分别对输入和输出参数使用参数和 Oracle TO_DATE 或 TO_CHAR 转换函数。To bind BC dates, use a String parameter and the Oracle TO_DATE or TO_CHAR conversion functions for input and output parameters respectively.

构造函数

Initializes a new instance of the OracleDateTime structure with the specified DateTime.

通过使用所提供的参数初始化新结构的年、月和日来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, and day of the new structure.

通过使用所提供的参数初始化新结构的年、月、日和日历，来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, and calendar of the new structure.

通过使用所提供的参数初始化新结构的年、月、日、小时、分钟和秒，来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, and second of the new structure.

通过使用所提供的参数初始化新结构指定日历的年、月、日、小时、分钟和秒，来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, and second for the specified calendar of the new structure.

通过使用所提供的参数初始化新结构的年、月、日、小时、分钟、秒和毫秒，来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and millisecond of the new structure.

通过使用所提供的参数初始化新结构的指定日历的年、月、日、小时、分钟、秒和毫秒，来初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and millisecond for the specified calendar of the new structure.

使用所提供的刻度数初始化 OracleDateTime 结构的新实例。Initializes a new instance of the OracleDateTime structure using the supplied number of ticks.

字段

Represents the maximum valid date value for an OracleDateTime structure.

Represents the minimum valid date value for an OracleDateTime structure.

表示可分配给 Value 结构实例的 OracleDateTime 属性的 null 值。Represents a null value that can be assigned to the Value property of an instance of the OracleDateTime structure.

属性

Gets the value of the OracleDateTime structure as a day.

Gets the value of the OracleDateTime structure as an hour.

获取一个值，该值指示 Value 结构的 OracleDateTime 属性是否为 null。Gets a value indicating whether the Value property of the OracleDateTime structure is null.

获取此实例所表示日期的毫秒部分。Gets the milliseconds component of the date represented by this instance.

Gets the value of the OracleDateTime structure as a minute.

Gets the value of the OracleDateTime structure as a month.

Gets the value of the OracleDateTime structure as a second.

Gets the value of the OracleDateTime structure.

Gets the value of the OracleDateTime structure as a year.

方法

将此 OracleDateTime 结构与所提供的对象进行比较，并返回其相对值的指示。Compares this OracleDateTime structure to the supplied object and returns an indication of their relative values.

将提供的对象参数与 Value 对象的 OracleDateTime 属性进行比较。Compares the supplied object parameter to the Value property of the OracleDateTime object.

对两个 OracleDateTime 结构执行逻辑比较，以确定它们是否相等。Performs a logical comparison of two OracleDateTime structures to determine whether they are equal.

获取此实例的哈希代码。Gets the hash code for this instance.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否大于第二个实例。Compares two instances of OracleDateTime to determine whether the first is greater than the second.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否大于或等于第二个实例。Compares two instances of OracleDateTime to determine whether the first is greater than or equal to the second.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否小于第二个实例。Compares two instances of OracleDateTime to determine whether the first is less than the second.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否小于或等于第二个实例。Compares two instances of OracleDateTime to determine whether the first is less than or equal to the second.

对 OracleDateTime 的两个实例执行逻辑比较，确定它们是否相等。Performs a logical comparison of two instances of OracleDateTime to determine if they are not equal.

将日期和时间的指定的 String 表示形式转换为其等效的 OracleDateTime 形式。Converts the specified String representation of a date and time to its OracleDateTime equivalent.

运算符

对两个 OracleDateTime 结构执行逻辑比较，以确定它们是否相等。Performs a logical comparison of two OracleDateTime structures to determine if they are equal.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否大于第二个实例。Compares two instances of OracleDateTime to determine if the first is greater than the second.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否大于或等于第二个实例。Compares two instances of OracleDateTime to determine if the first is greater than or equal to the second.

对 OracleDateTime 的两个实例执行逻辑比较，以确定它们是否相等。Performs a logical comparison of two instances of OracleDateTime to determine if they are equal.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否小于第二个实例。Compares two instances of OracleDateTime to determine if the first is less than the second.

对 OracleDateTime 的两个实例进行比较，以确定第一个实例是否小于或等于第二个实例。Compares two instances of OracleDateTime to determine if the first is less than or equal to the second.

适用于