SqlDateTime Constructors
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.SqlDateTimePublic 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.SqlDateTimePublic 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.SqlDateTimePublic 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.SqlDateTimePublic 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.SqlDateTimePublic 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.SqlDateTimePublic 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.
