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 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.
public value class SqlDateTime : IComparable, IEquatable<System::Data::SqlTypes::SqlDateTime>, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlDateTime : IComparable, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlDateTime : IComparable, System::Data::SqlTypes::INullable
public struct SqlDateTime : IComparable, IEquatable<System.Data.SqlTypes.SqlDateTime>, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlDateTime : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlDateTime : IComparable, System.Data.SqlTypes.INullable
[System.Serializable]
public struct SqlDateTime : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
type SqlDateTime = struct
interface INullable
interface IXmlSerializable
type SqlDateTime = struct
interface INullable
[<System.Serializable>]
type SqlDateTime = struct
interface INullable
interface IXmlSerializable
Public Structure SqlDateTime
Implements IComparable, IEquatable(Of SqlDateTime), INullable, IXmlSerializable
Public Structure SqlDateTime
Implements IComparable, INullable, IXmlSerializable
Public Structure SqlDateTime
Implements IComparable, INullable
Initializes a new instance of the SqlDateTime structure using the specified DateTime value.
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.
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 microsecond of the new structure.
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.
SqlDateTime(Int32, Int32, Int32)Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day.
SqlDateTime(Int32, Int32)Initializes a new instance of the SqlDateTime structure using the supplied parameters.
Fields Properties Methods Operators Addition(SqlDateTime, TimeSpan)Adds the period of time indicated by the supplied TimeSpan parameter, t
, to the supplied SqlDateTime structure.
Performs a logical comparison of two SqlDateTime structures to determine whether they are equal.
Explicit(SqlDateTime to DateTime)Converts the SqlDateTime structure to a DateTime structure.
Explicit(SqlString to SqlDateTime)Converts the SqlString parameter to a SqlDateTime.
GreaterThan(SqlDateTime, SqlDateTime)Compares two instances of SqlDateTime to determine whether the first is greater than the second.
GreaterThanOrEqual(SqlDateTime, SqlDateTime)Compares two instances of SqlDateTime to determine whether the first is greater than or equal to the second.
Implicit(DateTime to SqlDateTime)Converts a DateTime structure to a SqlDateTime structure.
Inequality(SqlDateTime, SqlDateTime)Performs a logical comparison of two instances of SqlDateTime to determine whether they are not equal.
LessThan(SqlDateTime, SqlDateTime)Compares two instances of SqlDateTime to determine whether the first is less than the second.
LessThanOrEqual(SqlDateTime, SqlDateTime)Compares two instances of SqlDateTime to determine whether the first is less than or equal to the second.
Subtraction(SqlDateTime, TimeSpan)Subtracts the supplied TimeSpan structure, t
, from the supplied SqlDateTime structure.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4