Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

SqlDateTime Structure

.NET Framework 4

Represents the date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds to be stored in or retrieved from a database. The SqlDateTime structure has a different underlying data structure from its corresponding .NET Framework type, DateTime, which can represent any time between 12:00:00 AM 1/1/0001 and 11:59:59 PM 12/31/9999, to the accuracy of 100 nanoseconds. SqlDateTime actually stores the relative difference to 00:00:00 AM 1/1/1900. Therefore, a conversion from "00:00:00 AM 1/1/1900" to an integer will return 0.

Namespace:  System.Data.SqlTypes
Assembly:  System.Data (in System.Data.dll)
C#
C++
F#
VB
Copy 
[SerializableAttribute]
public struct SqlDateTime : INullable, 
	IComparable, IXmlSerializable

The SqlDateTime type exposes the following members.

  Name Description
Public method Supported by the XNA Framework SqlDateTime(DateTime) Initializes a new instance of the SqlDateTime structure using the specified DateTime value.
Public method Supported by the XNA Framework SqlDateTime(Int32, Int32) Initializes a new instance of the SqlDateTime structure using the supplied parameters.
Public method Supported by the XNA Framework SqlDateTime(Int32, Int32, Int32) Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day.
Public method Supported by the XNA Framework SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32) Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, and second of the new structure.
Public method Supported by the XNA Framework SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Double) Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and millisecond of the new structure.
Public method Supported by the XNA Framework SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32) Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day, hour, minute, second, and billisecond of the new structure.
Top
  Name Description
Public property Supported by the XNA Framework DayTicks Gets the number of ticks representing the date of this SqlDateTime structure.
Public property Supported by the XNA Framework IsNull Indicates whether this SqlDateTime structure is null.
Public property Supported by the XNA Framework TimeTicks Gets the number of ticks representing the time of this SqlDateTime structure.
Public property Supported by the XNA Framework Value Gets the value of the SqlDateTime structure. This property is read-only.
Top
  Name Description
Public method Static member Supported by the XNA Framework Add Adds a SqlDateTime to the specified TimeSpan.
Public method Supported by the XNA Framework CompareTo(Object) Compares this SqlDateTime structure to the supplied Object and returns an indication of their relative values.
Public method Supported by the XNA Framework CompareTo(SqlDateTime) Compares this SqlDateTime structure to the supplied SqlDateTime structure and returns an indication of their relative values.
Public method Supported by the XNA Framework Equals(Object) Compares the supplied object parameter to the Value property of the SqlDateTime object. (Overrides ValueType.Equals(Object).)
Public method Static member Supported by the XNA Framework Equals(SqlDateTime, SqlDateTime) Performs a logical comparison of two SqlDateTime structures to determine whether they are equal.
Protected method Supported by the XNA Framework Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method Supported by the XNA Framework GetHashCode Gets the hash code for this instance. (Overrides ValueType.GetHashCode().)
Public method Supported by the XNA Framework GetType Gets the Type of the current instance. (Inherited from Object.)
Public method Static member Supported by the XNA Framework GetXsdType Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
Public method Static member Supported by the XNA Framework GreaterThan Compares two instances of SqlDateTime to determine whether the first is greater than the second.
Public method Static member Supported by the XNA Framework GreaterThanOrEqual Compares two instances of SqlDateTime to determine whether the first is greater than or equal to the second.
Public method Static member Supported by the XNA Framework LessThan Compares two instances of SqlDateTime to determine whether the first is less than the second.
Public method Static member Supported by the XNA Framework LessThanOrEqual Compares two instances of SqlDateTime to determine whether the first is less than or equal to the second.
Protected method Supported by the XNA Framework MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method Static member Supported by the XNA Framework NotEquals Performs a logical comparison of two instances of SqlDateTime to determine whether they are not equal.
Public method Static member Supported by the XNA Framework Parse Converts the specified String representation of a date and time to its SqlDateTime equivalent.
Public method Static member Supported by the XNA Framework Subtract Subtracts the specified Timespan from this SqlDateTime instance.
Public method Supported by the XNA Framework ToSqlString Converts this SqlDateTime structure to SqlString.
Public method Supported by the XNA Framework ToString Converts this SqlDateTime structure to a String. (Overrides ValueType.ToString().)
Top
  Name Description
Public operator Static member Supported by the XNA Framework Addition Adds the period of time indicated by the supplied TimeSpan parameter, t, to the supplied SqlDateTime structure.
Public operator Static member Supported by the XNA Framework Equality Performs a logical comparison of two SqlDateTime structures to determine whether they are equal.
Public operator Static member Supported by the XNA Framework Explicit(SqlDateTime to DateTime) Converts the SqlDateTime structure to a DateTime structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlString to SqlDateTime) Converts the SqlString parameter to a SqlDateTime.
Public operator Static member Supported by the XNA Framework GreaterThan Compares two instances of SqlDateTime to determine whether the first is greater than the second.
Public operator Static member Supported by the XNA Framework GreaterThanOrEqual Compares two instances of SqlDateTime to determine whether the first is greater than or equal to the second.
Public operator Static member Supported by the XNA Framework Implicit(DateTime to SqlDateTime) Converts a DateTime structure to a SqlDateTime structure.
Public operator Static member Supported by the XNA Framework Inequality Performs a logical comparison of two instances of SqlDateTime to determine whether they are not equal.
Public operator Static member Supported by the XNA Framework LessThan Compares two instances of SqlDateTime to determine whether the first is less than the second.
Public operator Static member Supported by the XNA Framework LessThanOrEqual Compares two instances of SqlDateTime to determine whether the first is less than or equal to the second.
Public operator Static member Supported by the XNA Framework Subtraction Subtracts the supplied TimeSpan structure, t, from the supplied SqlDateTime structure.
Top
  Name Description
Public field Static member Supported by the XNA Framework MaxValue Represents the maximum valid date value for a SqlDateTime structure.
Public field Static member Supported by the XNA Framework MinValue Represents the minimum valid date value for a SqlDateTime structure.
Public field Static member Supported by the XNA Framework Null Represents a DBNull that can be assigned to this instance of the SqlDateTime structure.
Public field Static member Supported by the XNA Framework SQLTicksPerHour A constant whose value is the number of ticks equivalent to one hour.
Public field Static member Supported by the XNA Framework SQLTicksPerMinute A constant whose value is the number of ticks equivalent to one minute.
Public field Static member Supported by the XNA Framework SQLTicksPerSecond A constant whose value is the number of ticks equivalent to one second.
Top
  Name Description
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.GetSchema This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.ReadXml This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.WriteXml This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Top

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ