Difference between revisions of "TIMEOFDAY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 15: | Line 15: | ||
|- | |- | ||
| ||Same as TIME() hh:mm:ss | | ||Same as TIME() hh:mm:ss | ||
| + | |- | ||
| + | |0||Same as TIME() hh:mm:ss | ||
|- | |- | ||
|1||MM-DD-YYYY hh:mm:ss:xxx (24hr) | |1||MM-DD-YYYY hh:mm:ss:xxx (24hr) | ||
| Line 32: | Line 34: | ||
// hh:mm:ss | // hh:mm:ss | ||
> ? timeofday() | > ? timeofday() | ||
| + | 14:43:26 | ||
| + | > ? timeofday(0) | ||
14:43:26 | 14:43:26 | ||
//MM-DD-YYYY hh:mm:ss:xxx (24hr) | //MM-DD-YYYY hh:mm:ss:xxx (24hr) | ||
Revision as of 06:50, 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 | MM-DD-YYYY hh:mm:ss:xxx (24hr) |
| 2 | hh:mm:ss:xxx (24hr) |
| 3 | Seconds since midnight |
| 4 | Seconds since TIMEOFDAY() last called |
| 5 | YYYYMMDDhh:mm:ss |
Example
// hh:mm:ss > ? timeofday() 14:43:26 > ? timeofday(0) 14:43:26 //MM-DD-YYYY hh:mm:ss:xxx (24hr) > ? timeofday(1) 11-06-2009 14:44:33.036 // hh:mm:ss:xxx (24hr) > ? timeofday(2) 14:44:41.012 //seconds since midnight > ? timeofday(3) 53088.540 //seconds since TIMEOFDAY() last called > ? timeofday(4) 5.248 //YYYYMMDDhh:mm:ss > ? timeofday(5) 2009110614:44:58
