Difference between revisions of "SECS()"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return the number of seconds since midnight | Function to return the number of seconds since midnight | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[AMPM()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[ELAPTIME()]], [[HOUR()]], [[HOURS()]], [[MINUTE()]], [[MINUTES()]], [[SEC()]], [[SECONDS()]], [[ | + | [[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()]] |
| Line 38: | Line 31: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Date and Time Data]] | ||
| + | [[Category:Date and Time Data Functions]] | ||
Latest revision as of 15:27, 7 December 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, Recital Server
