跳到主要内容
版本：3.3

dayofyear

功能​

计算指定日期为对应年中的哪一天。

参数为 DATE 或 DATETIME 类型。

语法​

INT DAYOFYEAR(DATETIME date)

示例​

select dayofyear('2007-02-03 00:00:00');
+----------------------------------+
| dayofyear('2007-02-03 00:00:00') |
+----------------------------------+
|                               34 |
+----------------------------------+
Rocky the happy otterStarRocks Assistant

AI generated answers are based on docs and other sources. Please test answers in non-production environments.