Parameters
- i
- The zero-based column ordinal.
Return Value
The value of the specified column as a System.TimeSpan.
Call IsDBNull to check for null values before calling this method.
static void GetMyTimeSpan(DB2Connection myConnection) { DB2Command cmd = new DB2Command("SELECT * FROM AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { DB2DataReader reader = cmd.ExecuteReader(); reader.Read(); TimeSpan recievedTime = reader.GetTimeSpan(reader.GetOrdinal("TimeCol")); reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyTimeSpan(ByVal myConnection As DB2Connection) Dim cmd As New DB2Command("SELECT * FROM AllTypes") cmd.Connection = myConnection myConnection.Open() Try Dim reader As DB2DataReader = cmd.ExecuteReader reader.Read() Dim recievedTime As TimeSpan = reader.GetTimeSpan(reader.GetOrdinal("TimeCol")) reader.Close() Finally myConnection.Close() End Try End Sub