SECOND - Returning the Second of a Specified Time- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	SECOND(text/date,format)	Returns the second of a specified time. The returned value is an integer ranging from 0 to 59.
Parameter 1	text/date	Represents the time from which the second is to be extracted.
Parameter 2	Format
Type of the Returned Value	Value

Notes

The function allows the parameters to be empty. That is to say, you can simply use SECOND(). When the parameters are empty, the function returns the second of the current system server time.

If any parameter is NULL, the result is NULL.

Example

Formula	Result
SECOND()	2, corresponding to the system server time at 2020-10-23 15:36:02.
SECOND("15:36:25")	25
SECOND("15:36:25","HH:mm:ss")	25

Helpful
Not helpful
Only read

中文（简体）

English

SECOND - Returning the Second of a Specified Time

Overview

Notes

Example

附件列表