SqlDateTime Constructors

Definition

Initializes a new instance of the SqlDateTime structure.

Overloads

SqlDateTime(DateTime)

Initializes a new instance of the SqlDateTime structure using the specified DateTime value.

SqlDateTime(Int32, Int32)

Initializes a new instance of the SqlDateTime structure using the supplied parameters.

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, 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, 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(DateTime)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

Initializes a new instance of the SqlDateTime structure using the specified DateTime value.

public:
 SqlDateTime(DateTime value);
public SqlDateTime (DateTime value);
new System.Data.SqlTypes.SqlDateTime : DateTime -> System.Data.SqlTypes.SqlDateTime
Public Sub New (value As DateTime)

Parameters

value
DateTime

A DateTime structure.

See also

Applies to

SqlDateTime(Int32, Int32)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

Initializes a new instance of the SqlDateTime structure using the supplied parameters.

public:
 SqlDateTime(int dayTicks, int timeTicks);
public SqlDateTime (int dayTicks, int timeTicks);
new System.Data.SqlTypes.SqlDateTime : int * int -> System.Data.SqlTypes.SqlDateTime
Public Sub New (dayTicks As Integer, timeTicks As Integer)

Parameters

dayTicks
Int32

An integer value that represents the date as ticks.

timeTicks
Int32

An integer value that represents the time as ticks.

See also

Applies to

SqlDateTime(Int32, Int32, Int32)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

Initializes a new instance of the SqlDateTime structure using the supplied parameters to initialize the year, month, day.

public:
 SqlDateTime(int year, int month, int day);
public SqlDateTime (int year, int month, int day);
new System.Data.SqlTypes.SqlDateTime : int * int * int -> System.Data.SqlTypes.SqlDateTime
Public Sub New (year As Integer, month As Integer, day As Integer)

Parameters

year
Int32

An integer representing the year of the of the new SqlDateTime structure.

month
Int32

An integer value representing the month of the new SqlDateTime structure.

day
Int32

An integer value representing the day number of the new SqlDateTime structure.

See also

Applies to

SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

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:
 SqlDateTime(int year, int month, int day, int hour, int minute, int second);
public SqlDateTime (int year, int month, int day, int hour, int minute, int second);
new System.Data.SqlTypes.SqlDateTime : int * int * int * int * int * int -> System.Data.SqlTypes.SqlDateTime
Public Sub New (year As Integer, month As Integer, day As Integer, hour As Integer, minute As Integer, second As Integer)

Parameters

year
Int32

An integer value representing the year of the new SqlDateTime structure.

month
Int32

An integer value representing the month of the new SqlDateTime structure.

day
Int32

An integer value representing the day of the month of the new SqlDateTime structure.

hour
Int32

An integer value representing the hour of the new SqlDateTime structure.

minute
Int32

An integer value representing the minute of the new SqlDateTime structure.

second
Int32

An integer value representing the second of the new SqlDateTime structure.

See also

Applies to

SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Double)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

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:
 SqlDateTime(int year, int month, int day, int hour, int minute, int second, double millisecond);
public SqlDateTime (int year, int month, int day, int hour, int minute, int second, double millisecond);
new System.Data.SqlTypes.SqlDateTime : int * int * int * int * int * int * double -> System.Data.SqlTypes.SqlDateTime
Public Sub New (year As Integer, month As Integer, day As Integer, hour As Integer, minute As Integer, second As Integer, millisecond As Double)

Parameters

year
Int32

An integer value representing the year of the new SqlDateTime structure.

month
Int32

An integer value representing the month of the new SqlDateTime structure.

day
Int32

An integer value representing the day of the month of the new SqlDateTime structure.

hour
Int32

An integer value representing the hour of the new SqlDateTime structure.

minute
Int32

An integer value representing the minute of the new SqlDateTime structure.

second
Int32

An integer value representing the second of the new SqlDateTime structure.

millisecond
Double

An double value representing the millisecond of the new SqlDateTime structure.

See also

Applies to

SqlDateTime(Int32, Int32, Int32, Int32, Int32, Int32, Int32)

Source:
SQLDateTime.cs
Source:
SQLDateTime.cs
Source:
SQLDateTime.cs

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.

public:
 SqlDateTime(int year, int month, int day, int hour, int minute, int second, int bilisecond);
public SqlDateTime (int year, int month, int day, int hour, int minute, int second, int bilisecond);
new System.Data.SqlTypes.SqlDateTime : int * int * int * int * int * int * int -> System.Data.SqlTypes.SqlDateTime
Public Sub New (year As Integer, month As Integer, day As Integer, hour As Integer, minute As Integer, second As Integer, bilisecond As Integer)

Parameters

year
Int32

An integer value representing the year of the new SqlDateTime structure.

month
Int32

An integer value representing the month of the new SqlDateTime structure.

day
Int32

An integer value representing the day of the new SqlDateTime structure.

hour
Int32

An integer value representing the hour of the new SqlDateTime structure.

minute
Int32

An integer value representing the minute of the new SqlDateTime structure.

second
Int32

An integer value representing the second of the new SqlDateTime structure.

bilisecond
Int32

An integer value representing the microsecond (thousandths of a millisecond) of the new SqlDateTime structure.

See also

Applies to