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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates 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 OracleDates. 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 OracleDates 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 OracleDates 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());
}
}