dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteDateTime Structure
Fields Properties Methods

In This Topic
    SQLiteDateTime Structure Members
    In This Topic

    The following tables list the members exposed by SQLiteDateTime.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the SQLiteDateTime structure.  
    Top
    Public Fields
     NameDescription
    Public Fieldstatic (Shared in Visual Basic)Returns the date 1970-01-01 00:00:00-00.  
    Public Fieldstatic (Shared in Visual Basic)Represents the maximum valid date for a SQLiteDateTime structure.  
    Public Fieldstatic (Shared in Visual Basic)Represents the minimum valid date for a SQLiteDateTime structure.  
    Public Fieldstatic (Shared in Visual Basic)Represents a negative infinity value that can be assigned to the SQLiteDateTime structure.  
    Public Fieldstatic (Shared in Visual Basic)Represents a NULL value that can be assigned to the SQLiteDateTime structure.  
    Public Fieldstatic (Shared in Visual Basic)Represents a positive infinity value that can be assigned to the SQLiteDateTime structure.  
    Public Fieldstatic (Shared in Visual Basic)Static field, containing all the formats of the DateTime string representations, that can be parsed by the Parse method.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets the day component of a SQLiteDateTime.  
    Public PropertyReturns the day of a week that corresponds to the current SQLiteDateTime value.  
    Public PropertyReturns ordinal of the day in a year that corresponds to the current SQLiteDateTime value.  
    Public PropertyGets the number of days in the date part of the structure (days since January 24.11.4714 BC).  
    Public PropertyGets the hour component of a SQLiteDateTime.  
    Public PropertyDetermines whether the current structure value represents only date (without time value).  
    Public PropertyIndicates whether the current structure value is finite or null.  
    Public PropertyGets a value indicating whether the SQLiteDateTime structure represents Null.  
    Public PropertyGets the microsecond component of a SQLiteDateTime.  
    Public PropertyGets the minute component of a SQLiteDateTime.  
    Public PropertyGets the month component of a SQLiteDateTime.  
    Public PropertyGets the second component of a SQLiteDateTime.  
    Public PropertyGets the time part of the SQLiteDateTime structure.  
    Public PropertyGets the number of microseconds in the time part of the structure.  
    Public PropertyDetermines the time difference between the local time stored in this SQLiteDateTime instance and coordinated universal time (UTC).  
    Public PropertyGets the date and time that is stored in the SQLiteDateTime structure.  
    Public PropertyGets the year component of a SQLiteDateTime.  
    Top
    Public Methods
     NameDescription
    Public Methodstatic (Shared in Visual Basic)Adds a SQLiteDateTime to a System.TimeSpan structure.  
    Public MethodAdds the specified number of days to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of hours to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of microseconds to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of minutes to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of months to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of seconds to the current SQLiteDateTime instance.  
    Public MethodAdds the specified number of years to the current SQLiteDateTime instance.  
    Public MethodOverloaded. Compares the current SQLiteDateTime object to the specified object.  
    Public Methodstatic (Shared in Visual Basic)Returns the number of days in the specified month and year.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Compares two SQLiteDateTime structures to determine if they are equal.  
    Public MethodGets a hash code for the SQLiteDateTime instance.  
    Public Methodstatic (Shared in Visual Basic)Determines whether the first of two SQLiteDateTime values is greater than the second.  
    Public Methodstatic (Shared in Visual Basic)Determines whether the first of two SQLiteDateTime values is greater than or equal to the second.  
    Public Methodstatic (Shared in Visual Basic)Indicates whether specified year is a leap one.  
    Public Methodstatic (Shared in Visual Basic)Determines whether the first of two SQLiteDateTime values is less than the second.  
    Public Methodstatic (Shared in Visual Basic)Determines whether the first of two SQLiteDateTime values is less than or equal to the second.  
    Public Methodstatic (Shared in Visual Basic)Determines whether two SQLiteDateTime values are not equal.  
    Public Methodstatic (Shared in Visual Basic)Converts the specified System.String representation of a date to its SQLiteDateTime equivalent.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Converts the specified System.String representation of a date to its SQLiteDateTime equivalent.  
    Public Methodstatic (Shared in Visual Basic)Subtracts a System.TimeSpan value from a SQLiteDateTime structure.  
    Public MethodOverloaded. Converts the current SQLiteDateTime structure to a System.String.  
    Top
    Public Operators
    Adds the specified System.TimeSpan to the SQLiteDateTime and returns a new SQLiteDateTime structure.
    Determines whether two SQLiteDateTime values are equal.
    Converts a SQLiteDateTime structure to the System.DateTime object.
    Compares two SQLiteDateTime structures to determine if the first is greater than the second.
    Compares two SQLiteDateTime structures to determine if the first is greater than or equal to the second.
    Converts a System.DateTime object to the SQLiteDateTime structure.
    Determines whether two SQLiteDateTime values are not equal.
    Compares two SQLiteDateTime structures to determine if the first is less than the second.
    Compares two SQLiteDateTime structures to determine if the first is less than or equal to the second.
    Subtracts the specified System.TimeSpan value from the SQLiteDateTime value and returns a new SQLiteDateTime structure.
    Top
    See Also