本文为您介绍如何使用实时计算日期函数SECOND。
语法
BIGINT SECOND(TIMESTAMP timestamp)
BIGINT SECOND(TIME time)
入参
参数 | 数据类型 |
---|---|
time | TIME |
timestamp | TIMESTAMP |
功能描述
返回输入时间参数中的“秒”部分,范围0~59。
示例
- 测试数据
datetime1(VARCHAR) time1(VARCHAR) time2(TIME) timestamp1(TIMESTAMP) 2017-10-15 11:12:13 22:23:24 22:23:24 2017-10-15 11:12:13 - 测试语句
SELECT SECOND(TIMESTAMP '2016-09-20 23:33:33') as int1, SECOND(TIME '23:30:33') as int2, SECOND(time2) as int3, SECOND(timestamp1) as int4, SECOND(CAST(time1 AS TIME)) as int5, SECOND(CAST(datetime1 AS TIMESTAMP)) as int6 FROM T1;
- 测试结果
int1(BIGINT) int2(BIGINT) int3(BIGINT) int4(BIGINT) int5(BIGINT) int6(BIGINT) 33 33 24 13 24 13