The following program adds an INTERVAL value to a DATETIME value and displays the result. */
#include
EXEC SQL include datetime;
main() { char out_str[16];
EXEC SQL BEGIN DECLARE SECTION; datetime year to minute dt_var, result; interval day to minute intvl; EXEC SQL END DECLARE SECTION;
printf("DTADDINV Sample ESQL Program running.\n\n");
printf("datetime year to minute value=2006-11-28 11:40\n"); dtcvasc("2006-11-28 11:40", &dt_var); printf("interval day to minute value = 50 10:20\n"); incvasc("50 10:20", &intvl);
dtaddinv(&dt_var, &intvl, &result);
/* Convert to ASCII for displaying */ dttoasc(&result, out_str); printf("---------------------------------------\n"); printf("Sum=%s\n", out_str);
GBase 8s ESQL/C 编程指南 南大通用数据技术股份有限公司 - 673 -
printf("\nDTADDINV Sample Program over.\n\n"); }
输出 DTADDINV Sample ESQL Program running.
datetime year to minute value=2006-11-28 11:40 interval day to minute value = 50 10:20 ----------------------------------------------- Sum=2007-01-17 22:00 DTADDINV Sample Program over.