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 OperatorOverloaded.  
Equality Operator 
Greater Than Operator 
Greater Than Or Equal Operator 
Inequality Operator 
Less Than Operator 
Less Than Or Equal Operator 
Subtraction OperatorOverloaded.  
Explicit NpgsqlInterval to NpgsqlTime Conversion 
Explicit NpgsqlTime to NpgsqlInterval Conversion 
Explicit NpgsqlTime to DateTime 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:
  1. time(0) - resolution of 1s (1 second)
  2. time(1) - resolution of 100ms = 0.1s (100 milliseconds)
  3. time(2) - resolution of 10ms = 0.01s (10 milliseconds)
  4. time(3) - resolution of 1ms = 0.001s (1 millisecond)
  5. time(4) - resolution of 100µs = 0.0001s (100 microseconds)
  6. time(5) - resolution of 10µs = 0.00001s (10 microseconds)
  7. 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 
CompareOverloaded.  
CompareToOverloaded.  
EqualsOverloaded.  
GetHashCode 
GetType (inherited from Object) 
Normalize Normalise this time; if it is 24:00:00, convert it to 00:00:00
SubtractOverloaded.  
ToString 

See Also

NpgsqlTime Class | NpgsqlTypes Namespace