Difference between revisions of "SECS()"

Revision as of 16:12, 28 October 2009

Purpose

Function to return the number of seconds since midnight

Syntax

SECS([<time-string>])

See Also

AMPM(), CTOT(), DATE(), DATETIME(), ELAPTIME(), HOUR(), HOURS(), MINUTE(), MINUTES(), SEC(), SECONDS(), SET CLIPPER, SET CLOCK, SET CLOCKRATE, SET SECONDS, SET VAXTIME, TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME()

Description

The SECS() function returns the number of seconds since midnight. The optional <time-string>, in the format HH:MM:SS, may be used to specify a time. If no <time-string> is passed, the SECS() function uses the current time. This function can be used to store time as seconds in a numeric field. The TSTRING() function is used to convert the seconds back to a time-string. If SET CLIPPER is ON, the SECS() function behaves like the SECONDS() function.

Example

? secs("10:10:10")
     36610
 
// Another Example
use accounts
replace seconds with secs(time())
? seconds
     39306
? tstring(seconds)
10:55:00

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer