下列 fmtstring 与 input 的组合是有效的。 格式化掩码输入 mmddyy Dec. 25th, 2007 mmddyyyy Dec. 25th, 2007 mmm. dd. yyyy dec 25 2007 mmm. dd. yyyy DEC-25-2007 mmm. dd. yyyy 122507 mmm. dd. yyyy 12/25/07 yy/mm/dd 07/12/25 yy/mm/dd 2007, December 25 yy/mm/dd In the year 2007, the month of December, it is the 25th day dd-mm-yy This 25th day of December 2007
The following program illustrates the results of datetime extension. The fields to the right are filled with zeros,and the fields to the left are filled in from current date and time. */
#include
EXEC SQL include datetime;
main() { mint x; char year_str[20];
EXEC SQL BEGIN DECLARE SECTION; datetime month to day month_dt; datetime year to minute year_min; EXEC SQL END DECLARE SECTION;
printf("DTEXTEND Sample ESQL Program running.\n\n");
GBase 8s ESQL/C 编程指南 南大通用数据技术股份有限公司 - 684 -
/* Assign value to month_dt and extend */ printf("Datetime (month to day) value = 12-07\n"); if(x = dtcvasc("12-07", &month_dt)) printf("Result = Error %d in dtcvasc()\n", x); else { if (x = dtextend(&month_dt, &year_min)) printf("Result = Error %d in dtextend()\n", x); else { dttoasc(&year_min, year_str); printf("Datetime (year to minute) extended value =%s\n", year_str); } }
printf("\nDTEXTEND Sample Program over.\n\n"); } 输出 DTEXTEND Sample ESQL Program running.
Datetime (month to day) value = 12-07 Datetime (year to minute) extended value = 2006-12-07 00:00 DTEXTEND Sample Program over.