类别：: 日期和时间函数

SECOND¶

Extracts the corresponding time part from a time, interval, or timestamp value.

这些函数是将 DATE_PART （或 EXTRACT）函数与等效时间部分一起使用的替代方法（请参阅支持的日期和时间部分）。

另请参阅：: YEAR* / DAY* / WEEK* / MONTH / QUARTER

语法¶

HOUR( <time_interval_or_timestamp_expr> )

MINUTE( <time_interval_or_timestamp_expr> )

SECOND( <time_interval_or_timestamp_expr> )

实参¶

time_interval_or_timestamp_expr: A time, an interval, or a timestamp, or an expression that can be evaluated to one of those data types. An interval argument must be a day and time interval, not a year and month interval.

返回¶

此函数返回 NUMBER 类型的值。

使用说明¶


函数名称	Time part extracted from time, interval, or timestamp	可能的值
HOUR	指定日期的小时数	0 到 23
MINUTE	指定小时的分钟数	0 到 59
SECOND	指定分钟的秒数	0 到 59

小技巧

To extract a full TIME value from a TIMESTAMP value instead of a part, you can cast the TIMESTAMP value to a TIME value. For example:

SELECT '2025-04-08T23:39:20.123-07:00'::TIMESTAMP::TIME AS full_time_value;

+-----------------+
| FULL_TIME_VALUE |
|-----------------|
| 23:39:20        |
+-----------------+

示例¶

此示例演示了 HOUR、MINUTE 和 SECOND 函数：

SELECT '2025-04-08T23:39:20.123-07:00'::TIMESTAMP AS tstamp,
       HOUR(tstamp) AS "HOUR",
       MINUTE(tstamp) AS "MINUTE",
       SECOND(tstamp) AS "SECOND";

+-------------------------+------+--------+--------+
| TSTAMP                  | HOUR | MINUTE | SECOND |
|-------------------------+------+--------+--------|
| 2025-04-08 23:39:20.123 |   23 |     39 |     20 |
+-------------------------+------+--------+--------+

有关更多示例，请参阅使用日期和时间值。