GBase 8s ESQL/C 编程指南 南大通用数据技术股份有限公司 - 677 - * dtcvasc.ec * The following program converts ASCII datetime strings in ANSI SQL format into datetime (dtime_t) structure. */
#include
EXEC SQL include datetime;
main() { mint x;
EXEC SQL BEGIN DECLARE SECTION; datetime year to second dt1; EXEC SQL END DECLARE SECTION;
printf("DTCVASC Sample ESQL Program running.\n\n");
/* * Note that the following literal string has a 26 in the hours place */ printf("\nDatetime string #2 = 2007-02-04 26:10:35\n"); if (x = dtcvasc("2007-02-04 26:10:35", &dt1)) printf("Result = failed with conversion error: %d\n", x); else printf("Result = successful conversion\n");
GBase 8s ESQL/C 编程指南 南大通用数据技术股份有限公司 - 678 -
printf("\nDTCVASC Sample Program over.\n\n"); } 输出 DTCVASC Sample ESQL Program running.
Datetime string #1 = 2007-02-11 3:10:35 Result = successful conversion
Datetime string #2 = 2007-02-04 26:10:35 Result = failed with conversion error:-1263 DTCVASC Sample Program over.