.NET Framework Class Library  

SqlDateTime Members

SqlDateTime overview

Public Constructors

public constructorSqlDateTime Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlDateTime structure.

Public Fields

public fieldstatic (Shared in Visual Basic)MaxValue

Supported by the .NET Compact Framework.

Represents the maximum valid date value for a SqlDateTime structure.
public fieldstatic (Shared in Visual Basic)MinValue

Supported by the .NET Compact Framework.

Represents the minimum valid date value for a SqlDateTime structure.
public fieldstatic (Shared in Visual Basic)Null

Supported by the .NET Compact Framework.

Represents a null value that can be assigned to the Value property of an instance of the SqlDateTime structure.
public fieldstatic (Shared in Visual Basic)SQLTicksPerHour

Supported by the .NET Compact Framework.

A constant whose value is the number of ticks equivalent to one hour.
public fieldstatic (Shared in Visual Basic)SQLTicksPerMinute

Supported by the .NET Compact Framework.

A constant whose value is the number of ticks equivalent to one minute.
public fieldstatic (Shared in Visual Basic)SQLTicksPerSecond

Supported by the .NET Compact Framework.

A constant whose value is the number of ticks equivalent to one second.

Public Properties

public propertyDayTicks

Supported by the .NET Compact Framework.

Gets the number of ticks representing the date of this SqlDateTime structure.
public propertyIsNull

Supported by the .NET Compact Framework.

Gets a value indicating whether the Value property of the SqlDateTime structure is null.
public propertyTimeTicks

Supported by the .NET Compact Framework.

Gets the number of ticks representing the time of this SqlDateTime structure.
public propertyValue

Supported by the .NET Compact Framework.

Gets the value of the SqlDateTime structure. This property is read-only.

Public Methods

public methodCompareTo

Supported by the .NET Compact Framework.

Compares this SqlDateTime structure to the supplied object and returns an indication of their relative values.
public methodEquals

Supported by the .NET Compact Framework.

Overloaded.
public methodGetHashCode

Supported by the .NET Compact Framework.

Overridden. Gets the hash code for this instance.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodstatic (Shared in Visual Basic)GreaterThan

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is greater than the second.
public methodstatic (Shared in Visual Basic)GreaterThanOrEqual

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is greater than or equal to the second.
public methodstatic (Shared in Visual Basic)LessThan

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is less than the second.
public methodstatic (Shared in Visual Basic)LessThanOrEqual

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is less than or equal to the second.
public methodstatic (Shared in Visual Basic)NotEquals

Supported by the .NET Compact Framework.

Performs a logical comparison of two instances of SqlDateTime to determine if they are not equal.
public methodstatic (Shared in Visual Basic)Parse

Supported by the .NET Compact Framework.

Converts the specified String representation of a date and time to its SqlDateTime equivalent.
public methodToSqlString

Supported by the .NET Compact Framework.

Converts this SqlDateTime structure to SqlString.
public methodToString

Supported by the .NET Compact Framework.

Overridden. Converts this SqlDateTime structure to a String.

Public Operators and Type Conversions

public operatorstatic (Shared in Visual Basic)Addition Operator

Supported by the .NET Compact Framework.

Adds the amount of time indicated by the supplied TimeSpan parameter, t, to the supplied SqlDateTime structure.
public operatorstatic (Shared in Visual Basic)Equality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of two SqlDateTime structures to determine if they are equal.
public operatorstatic (Shared in Visual Basic)Greater Than Operator

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is greater than the second.
public operatorstatic (Shared in Visual Basic)Greater Than Or Equal Operator

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is greater than or equal to the second.
public operatorstatic (Shared in Visual Basic)Inequality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of two instances of SqlDateTime to determine if they are not equal.
public operatorstatic (Shared in Visual Basic)Less Than Operator

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is less than the second.
public operatorstatic (Shared in Visual Basic)Less Than Or Equal Operator

Supported by the .NET Compact Framework.

Compares two instances of SqlDateTime to determine if the first is less than or equal to the second.
public operatorstatic (Shared in Visual Basic)Subtraction Operator

Supported by the .NET Compact Framework.

Subtracts the supplied TimeSpan structure, t, from the from the supplied SqlDateTime structure.
public operatorstatic (Shared in Visual Basic)SqlDateTime to DateTime Conversion

Supported by the .NET Compact Framework.

Converts a SqlDateTime structure to a DateTime structure.
public operatorstatic (Shared in Visual Basic)SqlString to SqlDateTime Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlString to a SqlDateTime structure.
public operatorstatic (Shared in Visual Basic)DateTime to SqlDateTime Conversion

Supported by the .NET Compact Framework.

Converts a DateTime structure to a SqlDateTime structure.

Protected Methods

protected methodFinalize (inherited from Object)

Supported by the .NET Compact Framework.

Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlDateTime Structure | System.Data.SqlTypes Namespace