PgSqlInterval Structure

In This Topic

Represents the PostgreSQL INTERVAL data type. Each object of the PgSqlInterval class stores a period of time in years, months, days, hours, minutes, seconds, and milliseconds.

Syntax

Visual Basic
C#

'Declaration
 
Public Structure PgSqlInterval 
   Inherits System.ValueType
   Implements System.Data.SqlTypes.INullable, System.IComparable, System.Xml.Serialization.IXmlSerializable

public struct PgSqlInterval : System.ValueType, System.Data.SqlTypes.INullable, System.IComparable, System.Xml.Serialization.IXmlSerializable

Remarks

To obtain a PgSqlInterval object call the PgSqlDataReader.GetPgSqlInterval method of the PgSqlDataReader class.

The data for this type is stored as two separate values on the server. One value is integer number of months, another is number of seconds in the interval. When two PgSqlInterval objects are compared, both values are checked for equality, and, if either fails, two PgSqlInterval objects are considered different.

Inheritance Hierarchy

System.Object
System.ValueType
Devart.Data.PostgreSql.PgSqlInterval

Reference

PgSqlInterval Members
Devart.Data.PostgreSql Namespace
PgSqlTimeStamp Structure

Send Feedback