函数说明
返回日期date 对应的年和周;
YEARWEEK(date,start)中的参数start,形式和作用与WEEK()中mode 参数相
同。
示例
示例1
返回“2011-02-01”对应的年和周,模式为0。
gbase> SELECT YEARWEEK('2011-02-01',0) FROM t;
+--------------------------+
| YEARWEEK('2011-02-01',0) |
+--------------------------+
| 201105 |
+--------------------------+
1 row in set
示例2
当日期参数date 是一年的第一周或最后一周时,
返回的年份值可能与日期参数
给出的年份不一致。
gbase> SELECT YEARWEEK('2011-01-01') FROM t;
+------------------------+
| YEARWEEK('2011-01-01') |
+------------------------+
| 201052 |
+------------------------+
1 row in set
当YEARWEEK()函数的参数start 的值为0 或1 时,
周值的返回值不同于WEE
K()函数的返回值(0),WEEK()是根据给定的年返回周值。
gbase> SELECT YEARWEEK('2011-01-01',0),WEEK('2011-01-01',0) FROM t;
+--------------------------+----------------------+
| YEARWEEK('2011-01-01',0) | WEEK('2011-01-01',0) |
+--------------------------+----------------------+
| 201052 | 0 |
+--------------------------+----------------------+
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 916
1 row in set
gbase> SELECT YEARWEEK('2011-01-01',1),WEEK('2011-01-01',1) FROM t;
+--------------------------+----------------------+
| YEARWEEK('2011-01-01',1) | WEEK('2011-01-01',1) |
+--------------------------+----------------------+
| 201052 | 0 |
+--------------------------+----------------------+
1 row in set
gbase> QUIT
Bye
# gccli -uroot -p
Enter password:
GBase
client