Difference between revisions of "TIMEOFDAY()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 11: | Line 11: | ||
The TIMEOFDAY() function returns the current system time as a character string in the following formats. | The TIMEOFDAY() function returns the current system time as a character string in the following formats. | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=30%|<expN>||Description | + | !width="30%"|<expN>||Description |
|- | |- | ||
| ||Same as TIME() hh:mm:ss | | ||Same as TIME() hh:mm:ss |
Revision as of 10:31, 4 February 2013
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 | |
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 //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