Advantage Database Server

SECOND()

Advantage Concepts

SECOND()

Advantage Concepts

This is the first topic This is the last topic  

SECOND()

Advantage Concepts

This is the first topic This is the last topic  

Advantage Expression Engine function that returns the second portion of a time or timestamp value

 

Syntax

SECOND( <tTime> | <tTimeStamp> ) -> nSecond

 

Parameters

<tTime>  A time value to convert OR

<tTimeStamp> A timestamp value to convert

 

Return Values

SECOND() returns a number in the range of 0 to 59 as an integer numeric value.  If the time or timestamp argument is empty, SECOND() returns zero.

 

Remarks

SECOND() is a time conversion function used to return the second portion of a time or timestamp value.

 

Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.

 

See Also

HOUR()

MINUTE()