Name
SqlDateTime
Synopsis
A structure that represents a date and time that can range in value
from January 1, 1753 to December 31, 9999, with an accuracy of 3.33
milliseconds. This maps directly to the SQL Server
datetime
data type. It can also be used for the
smalldatetime
data type, which can store a date
and time from January 1, 1900 to June 6, 2079 with an accuracy of one
minute.
public struct SqlDateTime : INullable, IComparable { // Public Constructors public SqlDateTime(DateTimevalue
); public SqlDateTime(intdayTicks
, inttimeTicks
); public SqlDateTime(intyear
, intmonth
, intday
); public SqlDateTime(intyear
, intmonth
, intday
, inthour
, intminute
, intsecond
); public SqlDateTime(intyear
, intmonth
, intday
, inthour
, intminute
, intsecond
, doublemillisecond
); public SqlDateTime(intyear
, intmonth
, intday
, inthour
, intminute
, intsecond
, intbilisecond
); // Public Static Fields public static readonly SqlDateTime MaxValue; // =12/31/9999 11:59:59 PM public static readonly SqlDateTime MinValue; // =1/1/1753 12:00:00 AM public static readonly SqlDateTime Null; // =Null public static readonly int SQLTicksPerHour; // =1080000 public static readonly int SQLTicksPerMinute; // =18000 public static readonly int SQLTicksPerSecond; // =300 // Public Instance Properties public int DayTicks{get; } public bool IsNull{get; } // implements INullable public int TimeTicks{get; } public DateTime Value{get; } // Public Static Methods public static SqlBoolean Equals(SqlDateTimex
, SqlDateTime ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.