Difference between revisions of "SECS()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 10: | Line 10: | ||
==Description== | ==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. | 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. | ||
+ | |||
+ | From Lianja v2.0 milliseconds are included for the returned current system time. | ||
==Example== | ==Example== |
Revision as of 05:23, 9 June 2015
Contents
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 SECONDS, 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.
From Lianja v2.0 milliseconds are included for the returned current system time.
Example
? secs("10:10:10") 36610 // Another Example use accounts replace seconds with secs(time()) ? seconds 39306 ? tstring(seconds) 10:55:00