The invextend() function

The function discards any fields in in_inv that are to the right of the least-significant field in out_inv. The function completes any fields in out_inv that are not present in in_inv as follows:

• It fills the fields to the right of the least-significant field in in_inv with zeros.
• It sets the fields to the left of the most-significant field in in_inv to valid interval values.

The demo directory contains this sample program in the file invextend.ec. The example illustrates interval extension. In the second result, the output contains zeros in the seconds field, and the days field has been set to 3.

/*
   * invextend.ec *

   The following program illustrates INTERVAL extension. It extends an INTERVAL 
   value to another INTERVAL value with a different qualifier. Note that in the
   second example, the output contains zeros in the seconds field and the 
   days field has been set to 3. 
*/

#include <stdio.h>
EXEC SQL include datetime;

main()
{
    mint x;
    char out_str[16];
;
    EXEC SQL BEGIN DECLARE SECTION;
      interval hour to minute hrtomin;
      interval hour to hour hrtohr;
      interval day to second daytosec;
    EXEC SQL END DECLARE SECTION;

    printf("INVEXTEND Sample ESQL Program running.\n\n");

    printf("Interval (hour to minute) value =      75.27\n");
    incvasc("75:27", &hrtomin);

    /* Extend to hour-to-hour and convert the internal format to
     * ascii for displaying 
     */
    invextend(&hrtomin, &hrtohr);
    intoasc(&hrtohr, out_str);
    printf("Extended (hour to hour) value =    %s\n", out_str);  

    /* Extend to day-to-second and convert the internal format to
     * ascii for displaying

     */
   invextend(&hrtomin, &daytosec);
   intoasc(&daytosec, out_str);
   printf("Extended (day to second) value =: %s\n", out_str); 

    printf("\nINVEXTEND Sample Program over.\n\n");
}