Npgsql Api Docs |

# NpgsqlTime Members

NpgsqlTime overview

#### Public Static (Shared) Fields

AllBalls |

#### Public Static (Shared) Properties

Now |

#### Public Static (Shared) Methods

Parse |
TryParse |

#### Public Static (Shared) Operators and Type Conversions

Addition Operator | Overloaded.
Equality Operator |
Greater Than Operator |
Greater Than Or Equal Operator |
Inequality Operator |
Less Than Operator |
Less Than Or Equal Operator |
Subtraction Operator | Overloaded.
Explicit NpgsqlInterval to NpgsqlTime Conversion |
Explicit NpgsqlTime to NpgsqlInterval Conversion |
Explicit NpgsqlTime to TimeSpan Conversion |
Explicit TimeSpan to NpgsqlTime Conversion |

#### Public Instance Constructors

NpgsqlTime | Overloaded. Initializes a new instance of the NpgsqlTime class.

#### Public Instance Properties

Hours | Gets the number of whole hours held in the instance. Note that the time 24:00:00 can be stored for roundtrip compatibility. Any calculations on such a value will normalised it to 00:00:00.
Microseconds | Gets the number of whole microseconds held in the instance. An integer in the range [0, 999999].
Milliseconds | Gets the number of whole milliseconds held in the instance. An integer in the range [0, 999].
Minutes | Gets the number of whole minutes held in the instance. An integer in the range [0, 59].
Seconds | Gets the number of whole seconds held in the instance. An interger in the range [0, 59].
Ticks | The total number of ticks(100ns units) contained. This is the resolution of the NpgsqlTime type. The resolution of the PostgreSQL interval type is by default 1µs = 1,000 ns. It may be smaller as follows: time(0) - resolution of 1s (1 second) time(1) - resolution of 100ms = 0.1s (100 milliseconds) time(2) - resolution of 10ms = 0.01s (10 milliseconds) time(3) - resolution of 1ms = 0.001s (1 millisecond) time(4) - resolution of 100µs = 0.0001s (100 microseconds) time(5) - resolution of 10µs = 0.00001s (10 microseconds) time(6) or interval - resolution of 1µs = 0.000001s (1 microsecond) As such, if the 100-nanosecond resolution is significant to an application, a PostgreSQL time will not suffice for those purposes. In more frequent cases though, the resolution of time suffices. NpgsqlTime will always suffice to handle the resolution of any time value, and upon writing to the database, will be rounded to the resolution used. The number of ticks in the instance.

#### Public Instance Methods

Add |
AddTicks |
AtTimeZone |
Compare | Overloaded.
CompareTo | Overloaded.
Equals | Overloaded.
GetHashCode |
GetType (inherited from Object) |
Normalize | Normalise this time; if it is 24:00:00, convert it to 00:00:00
Subtract | Overloaded.
ToString |

#### See Also

NpgsqlTime Class | NpgsqlTypes Namespace