Difference between revisions of "TIMEOFDAY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 18: | Line 18: | ||
|0||Same as TIME() hh:mm:ss | |0||Same as TIME() hh:mm:ss | ||
|- | |- | ||
| − | |1|| | + | |1||xxx (milliseconds) |
|- | |- | ||
|2||hh:mm:ss:xxx (24hr) | |2||hh:mm:ss:xxx (24hr) | ||
|- | |- | ||
| − | |3|| | + | |3||ss:xxx since midnight |
|- | |- | ||
| − | |4|| | + | |4||ss:xxx since TIMEOFDAY() last called |
|- | |- | ||
|5||YYYYMMDDhh:mm:ss | |5||YYYYMMDDhh:mm:ss | ||
| + | |- | ||
| + | |6||YYYYMMDD | ||
| + | |- | ||
| + | |7||ss:xxx since TIMEOFDAY() last called. | ||
| + | Includes text postfix 'ms' (less than 1 second) or ' seconds' (more than 1 second). | ||
|- | |- | ||
|} | |} | ||
| Line 37: | Line 42: | ||
> ? timeofday(0) | > ? timeofday(0) | ||
14:43:26 | 14:43:26 | ||
| − | // | + | // xxx (milliseconds) |
> ? timeofday(1) | > ? timeofday(1) | ||
| − | + | 482 | |
// hh:mm:ss:xxx (24hr) | // hh:mm:ss:xxx (24hr) | ||
> ? timeofday(2) | > ? timeofday(2) | ||
14:44:41.012 | 14:44:41.012 | ||
| − | // | + | // ss:xxx since midnight |
> ? timeofday(3) | > ? timeofday(3) | ||
53088.540 | 53088.540 | ||
| − | // | + | // ss:xxx since TIMEOFDAY() last called |
> ? timeofday(4) | > ? timeofday(4) | ||
5.248 | 5.248 | ||
| − | //YYYYMMDDhh:mm:ss | + | // YYYYMMDDhh:mm:ss |
> ? timeofday(5) | > ? timeofday(5) | ||
| − | + | 2015110614:44:58 | |
| + | // YYYYMMDD | ||
| + | > ? timeofday(6) | ||
| + | 20151106 | ||
| + | // ss:xxx since TIMEOFDAY() last called with text postfix | ||
| + | > ? timeofday(7) | ||
| + | 5.248 seconds | ||
</code> | </code> | ||
Revision as of 07:19, 12 February 2016
Contents
Purpose
Function to return the current system time in a specified format
Syntax
TIMEOFDAY([<expN>])
See Also
AMPM(), CTOT(), DATE(), DATETIME(), ELAPTIME(), HOUR(), HOURS(), MINUTE(), MINUTES(), SEC(), SECONDS(), SECS(), SET SECONDS, SYS(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME()
Description
The TIMEOFDAY() function returns the current system time as a character string in the following formats.
| <expN> | Description |
|---|---|
| Same as TIME() hh:mm:ss | |
| 0 | Same as TIME() hh:mm:ss |
| 1 | xxx (milliseconds) |
| 2 | hh:mm:ss:xxx (24hr) |
| 3 | ss:xxx since midnight |
| 4 | ss:xxx since TIMEOFDAY() last called |
| 5 | YYYYMMDDhh:mm:ss |
| 6 | YYYYMMDD |
| 7 | ss:xxx since TIMEOFDAY() last called.
Includes text postfix 'ms' (less than 1 second) or ' seconds' (more than 1 second). |
Example
// hh:mm:ss > ? timeofday() 14:43:26 > ? timeofday(0) 14:43:26 // xxx (milliseconds) > ? timeofday(1) 482 // hh:mm:ss:xxx (24hr) > ? timeofday(2) 14:44:41.012 // ss:xxx since midnight > ? timeofday(3) 53088.540 // ss:xxx since TIMEOFDAY() last called > ? timeofday(4) 5.248 // YYYYMMDDhh:mm:ss > ? timeofday(5) 2015110614:44:58 // YYYYMMDD > ? timeofday(6) 20151106 // ss:xxx since TIMEOFDAY() last called with text postfix > ? timeofday(7) 5.248 seconds
