示例 demo 目录在文件 incvfmtasc.ec 中包含此样例程序。 /* *incvfmtasc.ec* The following program illustrates the conversion of two strings to three interval values. */
#include
EXEC SQL include datetime;
main() { char out_str[30]; char out_str2[30]; char out_str3[30]; mint x;
EXEC SQL BEGIN DECLARE SECTION; interval day to minute short_time; interval minute(5) to second moment; interval hour to second long_moment; EXEC SQL END DECLARE SECTION;
printf("INCVFMTASC Sample ESQL Program running.\n\n");
/*Convert the internal format to ascii in ANSI format, for displaying. */ x = intoasc(&short_time, out_str); printf("Interval value (day to minute) = %s\n", out_str);
/* Initialize moment */ printf("\nInterval value #2 = 428 minutes, 30 seconds\n"); x = incvfmtasc("428 minutes, 30 seconds", "%M minutes, %S seconds", &moment);
/* Convert the internal format to ascii in ANSI format, for displaying. */ x = intoasc(&moment, out_str2); printf("Interval value (minute to second) = %s\n", out_str2);
/*Convert the internal format to ascii in ANSI format, for displaying. */ x = intoasc(&long_moment, out_str3); printf("Interval value (hour to second) = %s\n", out_str3);
printf("\nINCVFMTASC Sample Program over.\n\n"); } 输出 INVCFMTASC Sample ESQL Program running.
Interval value #1 = 20 days, 3 hours, 40 minutes Interval value (day to minute) = 20 03:40
GBase 8s ESQL/C 编程指南 南大通用数据技术股份有限公司 - 830 -
Interval value #2 = 428 minutes, 30 seconds Interval value (minute to second) = 428:30
Interval value #3 = 428 minute, 30 seconds Interval value (hour to second) = 7:08:30