Obtaining time values

The .NET Framework does not have a Time structure. If you want to fetch time values from SQL Anywhere, you must use the GetTimeSpan method. Using this method returns the data as a .NET Framework TimeSpan object.

For more information about the GetTimeSpan method, see GetTimeSpan method.

To convert a time value using the GetTimeSpan method

  1. Declare and initialize a connection object.

    SAConnection conn = new SAConnection(
        "Data Source=dsn-time-test;UID=DBA;PWD=sql" );
  2. Open the connection.

    conn.Open();
  3. Add a Command object to define and execute a SQL statement.

    SACommand cmd = new SACommand(
        "SELECT ID, time_col FROM time_test", conn )
  4. Call the ExecuteReader method to return the DataReader object.

    SADataReader reader = cmd.ExecuteReader();

    The following code uses the GetTimeSpan method to return the time as TimeSpan.

    while ( reader.Read() )
    {
        int ID = reader.GetInt32();
        TimeSpan time = reader.GetTimeSpan();
    }
  5. Close the DataReader and Connection objects.

    reader.Close();
    conn.Close();