GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 851 -
对于 内部 DATE，rdayofweek() 函数返回星期几作为整数值。
语法
mint rdayofweek(jdate)
int4 jdate;
jdate
日期的内部表示。
返回代码
0
星期日
1
星期一
2
星期二
3
星期三
4
星期四
5
星期五
6
星期六
示例
demo 目录在 rdayofweek.ec 文件中包含此样例程序。
/*
* rdayofweek.ec *
The following program accepts a date entered from the console.
*/
GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 852 -
#include
main()
{
mint errnum;
int4 i_date;
char *day_name;
char date[20];
int x;
static char fmtstr[9] = "mmddyyyy";
printf("RDAYOFWEEK Sample ESQL Program running.\n\n");
/* Allow user to enter a date */
printf("Enter a date as a single string, month.day.year\n");
gets(date);
printf("\nThe date string is %s.\n", date);
/* Put entered date in internal format */
if (x = rdefmtdate(&i_date, fmtstr, date))
printf("Error %d on rdefmtdate conversion\n", x);
else
{
/* Figure out what day of the week i_date is */
switch (rdayofweek(i_date))
{
case 0: day_name = "Sunday";
break;
case 1: day_name = "Monday";
break;
GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 853 -
case 2: day_name = "Tuesday";
break;
case 3: day_name = "Wednesday";
break;
case 4: day_name = "Thursday";
break;
case 5: day_name = "Friday";
break;
case 6: day_name = "Saturday";
break;
}
printf("This date is a %s.\n", day_name);
}
printf("\nRDAYOFWEEK Sample Program over.\n\n");
}
输出
RDAYOFWEEK Sample ESQL Program running.
Enter a date as a single string, month.day.year
10.13.07
The date string is 10.13.07.
This date is a Saturday.
RDAYOFWEEK Sample Program over.