The OracleDate
structure represents the Oracle DATE
datatype to be stored in or retrieved from a database. Each OracleDate
stores the following information: year, month, day, hour, minute, and second.
Class Inheritance
Object
ValueType
OracleDate
Declaration
// C# public struct OracleDate : IComparable
Thread Safety
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
Example
// C# using System; using Oracle.DataAccess.Types; using Oracle.DataAccess.Client; class OracleDateSample { static void Main(string[] args) { // Initialize the dates to the lower and upper boundaries OracleDate date1 = OracleDate.MinValue; OracleDate date2 = OracleDate.MaxValue; OracleDate date3 = new OracleDate(DateTime.MinValue); OracleDate date4 = new OracleDate(DateTime.MaxValue); // Set the thread's DateFormat for output OracleGlobalization info = OracleGlobalization.GetClientInfo(); info.DateFormat = "DD-MON-YYYY BC"; OracleGlobalization.SetThreadInfo(info); // Print the lower and upper boundaries Console.WriteLine("OracleDate ranges from\n{0}\nto\n{1}\n", date1, date2); Console.WriteLine(".NET DateTime ranges from\n{0}\nto\n{1}\n", date3, date4); } }
Requirements
Namespace: Oracle.DataAccess.Types
Assembly: Oracle.DataAccess.dll
OracleDate
members are listed in the following tables:
OracleDate Constructors
OracleDate
constructors are listed in Table 11-14
Table 11-14 OracleDate Constructors
Constructor | Description |
---|---|
OracleDate Constructors | Instantiates a new instance of OracleDate structure (Overloaded) |
OracleDate Static Fields
The OracleDate
static fields are listed in Table 11-15.
Table 11-15 OracleDate Static Fields
Field | Description |
---|---|
MaxValue | Represents the maximum valid date for an OracleDate structure, which is December 31, 9999 23:59:59 |
MinValue | Represents the minimum valid date for an OracleDate structure, which is January 1, -4712 0:0:0 |
Null | Represents a null value that can be assigned to the value of an OracleDate structure instance |
OracleDate Static Methods
The OracleDate
static methods are listed in Table 11-16.
Table 11-16 OracleDate Static Methods
Methods | Description |
---|---|
Equals | Determines if two OracleDate values are equal (Overloaded) |
GreaterThan | Determines if the first of two OracleDate values is greater than the second |
GreaterThanOrEqual | Determines if the first of two OracleDate values is greater than or equal to the second |
LessThan | Determines if the first of two OracleDate values is less than the second |
LessThanOrEqual | Determines if the first of two OracleDate values is less than or equal to the second |
NotEquals | Determines if two OracleDate values are not equal |
GetSysDate | Returns an OracleDate structure that represents the current date and time |
Parse | Returns an OracleDate structure and sets its value using a string |
OracleDate Static Operators
The OracleDate
static operators are listed in Table 11-17.
Table 11-17 OracleDate Static Operators
Operator | Description |
---|---|
operator == | Determines if two OracleDate values are the same |
operator > | Determines if the first of two OracleDate values is greater than the second |
operator >= | Determines if the first of two OracleDate values is greater than or equal to the second |
operator != | Determines if the two OracleDate values are not equal |
operator < | Determines if the first of two OracleDate values is less than the second |
operator <= | Determines if the first of two OracleDate values is less than or equal to the second |
OracleDate Static Type Conversions
The OracleDate
static type conversions are listed in Table 11-18.
Table 11-18 OracleDate Static Type Conversions
Operator | Description |
---|---|
explicit operator DateTime | Converts a structure to a DateTime structure |
explicit operator OracleDate | Converts a structure to an OracleDate structure (Overloaded) |
OracleDate Properties
The OracleDate
properties are listed in Table 11-19.
Table 11-19 OracleDate Properties
Properties | Description |
---|---|
BinData | Gets an array of bytes that represents an Oracle DATE in Oracle internal format |
Day | Gets the day component of an OracleDate method |
IsNull | Indicates whether or not the current instance has a null value |
Hour | Gets the hour component of an OracleDate |
Minute | Gets the minute component of an OracleDate |
Month | Gets the month component of an OracleDate |
Second | Gets the second component of an OracleDate |
Value | Gets the date and time that is stored in the OracleDate structure |
Year | Gets the year component of an OracleDate |
OracleDate Methods
The OracleDate
methods are listed in Table 11-20.
Table 11-20 OracleDate Methods
Methods | Description |
---|---|
CompareTo | Compares the current OracleDate instance to an object, and returns an integer that represents their relative values |
Equals | Determines whether or not an object has the same date and time as the current OracleDate instance (Overloaded) |
GetHashCode | Returns a hash code for the OracleDate instance |
GetDaysBetween | Calculates the number of days between the current OracleDate instance and an OracleDate structure |
GetType | Inherited from Object |
ToOracleTimeStamp | Converts the current OracleDate structure to an OracleTimeStamp structure |
ToString | Converts the current OracleDate structure to a string |
The OracleDate
constructors instantiates a new instance of the OracleDate
structure.
Overload List:
This constructor creates a new instance of the OracleDate
structure and sets its value for date and time using the supplied DateTime
value.
This constructor creates a new instance of the OracleDate
structure and sets its value using the supplied string.
This constructor creates a new instance of the OracleDate
structure and set its value for date using the supplied year, month, and day.
OracleDate(int, int, int, int, int, int)
This constructor creates a new instance of the OracleDate
structure and set its value for time using the supplied year, month, day, hour, minute, and second.
This constructor creates a new instance of the OracleDate
structure and sets its value to the provided byte array, which is in the internal Oracle DATE
format.
This constructor creates a new instance of the OracleDate
structure and sets its value for date and time using the supplied DateTime
value.
Declaration
// C#
public OracleDate (DateTime dt);
Parameters
dt
The provided DateTime
value.
Remarks
The OracleDate
structure only supports up to a second precision. The time value in the provided DateTime
structure that has a precision smaller than second is ignored.
This constructor creates a new instance of the OracleDate
structure and sets its value using the supplied string.
Declaration
// C#
public OracleDate (string dateStr);
Parameters
dateStr
A string that represents an Oracle DATE
.
Exceptions
ArgumentException
- The dateStr
is an invalid string representation of an Oracle DATE
or the dateStr
is not in the date format specified by the thread's OracleGlobalization
.DateFormat
property, which represents the Oracle NLS_DATE_FORMAT
parameter.
ArgumentNullException
- The dateStr
is null.
Remarks
The names and abbreviations used for months and days are in the language specified by the DateLanguage
and Calendar
properties of the thread's OracleGlobalization
object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.
Example
// C# using System; using Oracle.DataAccess.Types; using Oracle.DataAccess.Client; class OracleDateSample { static void Main(string[] args) { // Set the thread's DateFormat for the OracleDate constructor OracleGlobalization info = OracleGlobalization.GetClientInfo(); info.DateFormat = "YYYY-MON-DD"; OracleGlobalization.SetThreadInfo(info); // construct OracleDate from a string using the DateFormat specified. OracleDate date = new OracleDate("1999-DEC-01"); // Set a different DateFormat for the thread info.DateFormat = "MM/DD/YYYY"; OracleGlobalization.SetThreadInfo(info); // Print "12/01/1999" Console.WriteLine(date.ToString()); } }
This constructor creates a new instance of the OracleDate
structure and set its value for date using the supplied year, month, and day.
Declaration
// C# public OracleDate (int year, int month, int day);
Parameters
year
The supplied year. Range of year
is (-4712 to 9999).
month
The supplied month. Range of month
is (1 to 12).
day
The supplied day. Range of day
is (1 to 31).
Exceptions
ArgumentOutOfRangeException
- The argument value for one or more of the parameters is out of the specified range.
ArgumentException
- The argument values of the parameters cannot be used to construct a valid OracleDate
(that is, the day is out of range for the month).
This constructor creates a new instance of the OracleDate
structure and set its value for time using the supplied year, month, day, hour, minute, and second.
Declaration
// C# public OracleDate (int year, int month, int day, int hour, int minute, int second);
Parameters
year
The supplied year. Range of year
is (-4712 to 9999).
month
The supplied month. Range of month
is (1 to 12).
day
The supplied day. Range of day
is (1 to 31).
hour
The supplied hour. Range of hour
is (0 to 23).
minute
The supplied minute. Range of minute
is (0 to 59).
second
The supplied second. Range of second
is (0 to 59).
Exceptions
ArgumentOutOfRangeException
- The argument value for one or more of the parameters is out of the specified range.
ArgumentException
- The argument values of the parameters cannot be used to construct a valid OracleDate
(that is, the day is out of range for the month).
This constructor creates a new instance of the OracleDate
structure and sets its value to the provided byte array, which is in the internal Oracle DATE
format.
Declaration
// C#
public OracleDate(byte [] bytes);
Parameters
bytes
A byte array that represents Oracle DATE
in the internal Oracle DATE
format.
Exceptions
ArgumentException
- bytes
is null or bytes
is not in internal Oracle DATE
format or bytes
is not a valid Oracle DATE
.
The OracleDate
static fields are listed in Table 11-21.
Table 11-21 OracleDate Static Fields
Field | Description |
---|---|
MaxValue | Represents the maximum valid date for an OracleDate structure, which is December 31, 9999 23:59:59 |
MinValue | Represents the minimum valid date for an OracleDate structure, which is January 1, -4712 0:0:0 |
Null | Represents a null value that can be assigned to the value of an OracleDate structure instance |
This static field represents the maximum valid date for an OracleDate
structure, which is December 31, 9999 23:59:59.
Declaration
// C# public static readonly OracleDate MaxValue;
This static field represents the minimum valid date for an OracleDate
structure, which is January 1, -4712.
Declaration
// C# public static readonly OracleDate MinValue;
This static field represents a null value that can be assigned to the value of an OracleDate
instance.
Declaration
// C# public static readonly OracleDate Null;
The OracleDate
static methods are listed in Table 11-22.
Table 11-22 OracleDate Static Methods
Methods | Description |
---|---|
Equals | Determines if two OracleDate values are equal (Overloaded) |
GreaterThan | Determines if the first of two OracleDate values is greater than the second |
GreaterThanOrEqual | Determines if the first of two OracleDate values is greater than or equal to the second |
LessThan | Determines if the first of two OracleDate values is less than the second |
LessThanOrEqual | Determines if the first of two OracleDate values is less than or equal to the second |
NotEquals | Determines if two OracleDate values are not equal |
GetSysDate | Returns an OracleDate structure that represents the current date and time |
Parse | Returns an OracleDate structure and sets its value using a string |
Overloads Object
This method determines if two OracleDate
values are equal.
Declaration
// C# public static bool Equals(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if two OracleDate
values are equal; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is greater than the second.
Declaration
// C# public static bool GreaterThan(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is greater than the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is greater than or equal to the second.
Declaration
// C# public static bool GreaterThanOrEqual(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is greater than or equal to the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is less than the second.
Declaration
// C# public static bool LessThan(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is less than the second. Otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is less than or equal to the second.
Declaration
// C# public static bool LessThanOrEqual(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is less than or equal to the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if two OracleDate
values are not equal.
Declaration
// C# public static bool NotEquals(OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if two OracleDate
values are not equal; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method gets an OracleDate
structure that represents the current date and time.
Declaration
// C# public static OracleDate GetSysDate ();
Return Value
An OracleDate
structure that represents the current date and time.
This method gets an OracleDate
structure and sets its value for date and time using the supplied string.
Declaration
// C#
public static OracleDate Parse (string dateStr);
Parameters
dateStr
A string that represents an Oracle DATE
.
Return Value
An OracleDate
structure.
Exceptions
ArgumentException
- The dateStr
is an invalid string representation of an Oracle DATE
or the dateStr
is not in the date format specified by the thread's OracleGlobalization
.DateFormat
property, which represents the Oracle NLS_DATE_FORMAT
parameter.
ArgumentNullException
- The dateStr
is null.
Remarks
The names and abbreviations used for months and days are in the language specified by the DateLanguage
and Calendar
properties of the thread's OracleGlobalization
object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.
Example
// C# using System; using Oracle.DataAccess.Types; using Oracle.DataAccess.Client; class ParseSample { static void Main(string[] args) { // Set the thread's DateFormat for the OracleDate constructor OracleGlobalization info = OracleGlobalization.GetClientInfo(); info.DateFormat = "YYYY-MON-DD"; OracleGlobalization.SetThreadInfo(info); // Construct OracleDate from a string using the DateFormat specified OracleDate date = OracleDate.Parse("1999-DEC-01"); // Set a different DateFormat on the thread for ToString() info.DateFormat = "MM-DD-YY"; OracleGlobalization.SetThreadInfo(info); // Print "12-01-1999" Console.WriteLine(date.ToString()); } }
The OracleDate
static operators are listed in Table 11-23.
Table 11-23 OracleDate Static Operators
Operator | Description |
---|---|
operator == | Determines if two OracleDate values are the same |
operator > | Determines if the first of two OracleDate values is greater than the second |
operator >= | Determines if the first of two OracleDate values is greater than or equal to the second |
operator != | Determines if the two OracleDate values are not equal |
operator < | Determines if the first of two OracleDate values is less than the second |
operator <= | Determines if the first of two OracleDate values is less than or equal to the second |
This method determines if two OracleDate
values are the same.
Declaration
// C# public static bool operator == (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if they are the same; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is greater than the second.
Declaration
// C# public static bool operator > (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is greater than the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is greater than or equal to the second.
Declaration
// C# public static bool operator >= (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is greater than or equal to the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the two OracleDate
values are not equal.
Declaration
// C# public static bool operator != (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the two OracleDate
values are not equal; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is less than the second.
Declaration
// C# public static bool operator < (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is less than the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines if the first of two OracleDate
values is less than or equal to the second.
Declaration
// C# public static bool operator <= (OracleDate value1, OracleDate value2);
Parameters
value1
The first OracleDate
.
value2
The second OracleDate
.
Return Value
Returns true
if the first of two OracleDate
values is less than or equal to the second; otherwise, returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
The OracleDate
static type conversions are listed in Table 11-24.
Table 11-24 OracleDate Static Type Conversions
Operator | Description |
---|---|
explicit operator DateTime | Converts a structure to a DateTime structure |
explicit operator OracleDate | Converts a structure to an OracleDate structure (Overloaded) |
This method converts an OracleDate
structure to a DateTime
structure.
Declaration
// C#
public static explicit operator DateTime(OracleDate val);
Parameters
val
An OracleDate
structure.
Return Value
A DateTime
structure.
explicit
operator
OracleDate
converts the provided structure to an OracleDate
structure.
Overload List:
explicit operator OracleDate(DateTime)
This method converts a DateTime
structure to an OracleDate
structure.
explicit operator OracleDate(OracleTimeStamp)
This method converts an OracleTimeStamp
structure to an OracleDate
structure.
explicit operator OracleDate(string)
This method converts the supplied string to an OracleDate
structure.
This method converts a DateTime
structure to an OracleDate
structure.
Declaration
// C#
public static explicit operator OracleDate(DateTime dt);
Parameters
dt
A DateTime
structure.
Return Value
An OracleDate
structure.
This method converts an OracleTimeStamp
structure to an OracleDate
structure.
Declaration
// C#
public explicit operator OracleDate(OracleTimeStamp ts);
Parameters
ts
OracleTimeStamp
Return Value
The returned OracleDate
structure contains the date and time in the OracleTimeStamp
structure.
Remarks
The precision of the OracleTimeStamp
value can be lost during the conversion.
If the OracleTimeStamp
structure has a null value, the returned OracleDate
structure also has a null value.
This method converts the supplied string to an OracleDate
structure.
Declaration
// C#
public explicit operator OracleDate (string dateStr);
Parameters
dateStr
A string representation of an Oracle DATE
.
Return Value
The returned OracleDate
structure contains the date and time in the string dateStr
.
Exceptions
ArgumentNullException
- The dateStr
is null.
ArgumentException
- This exception is thrown if any of the following conditions exist:
The dateStr
is an invalid string representation of an Oracle DATE
.
The dateStr
is not in the date format specified by the thread's OracleGlobalization
.DateFormat
property, which represents the Oracle NLS_DATE_FORMAT
parameter.
Remarks
The names and abbreviations used for months and days are in the language specified by the DateLanguage
and Calendar
properties of the thread's OracleGlobalization
object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.
Example
// C# using System; using Oracle.DataAccess.Client; using Oracle.DataAccess.Types; class OracleDateSample { static void Main(string[] args) { // Set the thread's DateFormat to a specific format OracleGlobalization info = OracleGlobalization.GetClientInfo(); info.DateFormat = "YYYY-MON-DD"; OracleGlobalization.SetThreadInfo(info); // Construct OracleDate from a string using the DateFormat specified OracleDate date = (OracleDate)"1999-DEC-01"; // Set a different DateFormat on the thread for ToString() info.DateFormat = "MON DD YY"; OracleGlobalization.SetThreadInfo(info); // Prints "DEC 01 99" Console.WriteLine(date.ToString()); } }
The OracleDate
properties are listed in Table 11-25.
Table 11-25 OracleDate Properties
Properties | Description |
---|---|
BinData | Gets an array of bytes that represents an Oracle DATE in Oracle internal format |
Day | Gets the day component of an OracleDate method |
IsNull | Indicates whether or not the current instance has a null value |
Hour | Gets the hour component of an OracleDate |
Minute | Gets the minute component of an OracleDate |
Month | Gets the month component of an OracleDate |
Second | Gets the second component of an OracleDate |
Value | Gets the date and time that is stored in the OracleDate structure |
Year | Gets the year component of an OracleDate |
This property gets a array of bytes that represents an Oracle DATE
in Oracle internal format.
Declaration
// C# public byte[] BinData{get;}
Property Value
An array of bytes.
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property gets the day component of an OracleDate
.
Declaration
// C# public int Day{get;}
Property Value
A number that represents the day. Range of Day
is (1 to 31).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property indicates whether or not the current instance has a null value.
Declaration
// C# public bool IsNull{get;}
Property Value
Returns true
if the current instance has a null value; otherwise, returns false.
This property gets the hour
component of an OracleDate
.
Declaration
// C# public int Hour {get;}
Property Value
A number that represents Hour
. Range of Hour
is (0 to 23).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property gets the minute component of an OracleDate
.
Declaration
// C# public int Minute {get;}
Property Value
A number that represents Minute
. Range of Minute
is (0 to 59).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property gets the month
component of an OracleDate.
Declaration
// C# public int Month {get;}
Property Value
A number that represents Month
. Range of Month
is (1 to 12).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property gets the second
component of an OracleDate.
Declaration
// C# public int Second {get;}
Property Value
A number that represents Second
. Range of Second
is (0 to 59).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property specifies the date and time that is stored in the OracleDate
structure.
Declaration
// C# public DateTime Value {get;}
Property Value
A DateTime
.
Exceptions
OracleNullValueException
- OracleDate
has a null value.
This property gets the year
component of an OracleDate
.
Declaration
// C# public int Year {get;}
Property Value
A number that represents Year
. Range of Year
is (-4712 to 9999).
Exceptions
OracleNullValueException
- OracleDate
has a null value.
The OracleDate
methods are listed in Table 11-26.
Table 11-26 OracleDate Methods
Methods | Description |
---|---|
CompareTo | Compares the current OracleDate instance to an object, and returns an integer that represents their relative values |
Equals | Determines whether or not an object has the same date and time as the current OracleDate instance (Overloaded) |
GetHashCode | Returns a hash code for the OracleDate instance |
GetDaysBetween | Calculates the number of days between the current OracleDate instance and an OracleDate structure |
GetType | Inherited from Object |
ToOracleTimeStamp | Converts the current OracleDate structure to an OracleTimeStamp structure |
ToString | Converts the current OracleDate structure to a string |
This method compares the current OracleDate
instance to an object, and returns an integer that represents their relative values.
Declaration
// C#
public int CompareTo(object obj);
Parameters
obj
An object.
Return Value
The method returns:
Less than zero: if the current OracleDate
instance value is less than that of obj
.
Zero: if the current OracleDate
instance and obj
values are equal.
Greater than zero: if the current OracleDate
instance value is greater than obj
.
Implements
IComparable
Exceptions
ArgumentException
- The obj
parameter is not an instance of OracleDate
.
Remarks
The following rules apply to the behavior of this method.
The comparison must be between OracleDate
s. For example, comparing an OracleDate
instance with an OracleBinary
instance is not allowed. When an OracleDate
is compared with a different type, an ArgumentException
is thrown.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
This method determines whether or not an object has the same date and time as the current OracleDate
instance.
Declaration
// C#
public override bool Equals( object obj);
Parameters
obj
An object.
Return Value
Returns true
if obj
has the same type as the current instance and represents the same date and time; otherwise returns false
.
Remarks
The following rules apply to the behavior of this method.
Any OracleDate
that has a value compares greater than an OracleDate
that has a null value.
Two OracleDate
s that contain a null value are equal.
Overrides Object
This method returns a hash code for the OracleDate
instance.
Declaration
// C# public override int GetHashCode();
Return Value
A number that represents the hash code.
This method calculates the number of days between the current OracleDate
instance and the supplied OracleDate
structure.
Declaration
// C#
public int GetDaysBetween (OracleDate val);
Parameters
val
An OracleDate
structure.
Return Value
The number of days between the current OracleDate
instance and the OracleDate
structure.
Exceptions
OracleNullValueException
- The current instance or the supplied OracleDate
structure has a null value.
This method converts the current OracleDate
structure to an OracleTimeStamp
structure.
Declaration
// C# public OracleTimeStamp ToOracleTimeStamp();
Return Value
An OracleTimeStamp
structure.
Remarks
The returned OracleTimeStamp
structure has date and time in the current instance.
If the OracleDate
instance has a null value, the returned OracleTimeStamp
structure has a null value.
Overrides ValueType
This method converts the current OracleDate
structure to a string
.
Declaration
// C# public override string ToString();
Return Value
A string.
Remarks
The returned value is a string representation of the OracleDate
in the format specified by the thread's OracleGlobalization
.DateFormat
property. The names and abbreviations used for months and days are in the language specified by the thread's OracleGlobalization
.DateLanguage
and OracleGlobalization.Calendar
properties. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.
Example
// C# using System; using Oracle.DataAccess.Client; using Oracle.DataAccess.Types; class ToStringSample { static void Main(string[] args) { // Set the thread's DateFormat to a specific format OracleGlobalization info = OracleGlobalization.GetClientInfo(); info.DateFormat = "YYYY-MON-DD"; OracleGlobalization.SetThreadInfo(info); // Construct OracleDate from a string using the DateFormat specified OracleDate date = (OracleDate)"1999-DEC-01"; // Set a different DateFormat on the thread for ToString() info.DateFormat = "YYYY/MM/DD"; OracleGlobalization.SetThreadInfo(info); // Prints "1999/12/01" Console.WriteLine(date.ToString()); } }