quarterOfYear

语法

quarterOfYear(X)

参数

X 可以是DATE, MONTH, DATETIME, TIMESTAMP或NANOTIMESTAMP类型的标量或向量。

详情

计算X在当年的第几个季度。返回的结果是整型。

例子

$ quarterOfYear(2012.07.02);
3

$ quarterOfYear([2012.06.12T12:30:00,2012.10.28T12:35:00,2013.01.06T12:36:47,2013.04.06T08:02:14]);
[2,4,1,2]

相关函数：dayOfYear, dayOfMonth, monthOfYear, weekOfYear, hourOfDay, minuteOfHour, secondOfMinute, millisecond, microsecond, nanosecond