SECOND

语法

BIGINT SECOND(TIMESTAMP timestamp)
 BIGINT SECOND(TIME time)    

入参

功能描述

返回输入时间参数中的“秒”部分，范围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