$Time: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
|
(No difference)
|
Revision as of 13:45, 31 July 2014
Function
Returns the current time of day in the format specified.
Syntax
$TIME(time-format,'first-delimiter', 'second-delimiter')
Where
Argument | Value | Specifies | Default value |
---|---|---|---|
time-format | 1 | Returns the time of day as hhdmmdss (d=delimiter) | 1 |
2 | Returns the time of day as hhdmmdssdttt (d=delimiter) | ||
first-delimiter | 1 character only | Character to place between time units HH, MM, and SS | : (colon) |
second-delimiter | 1 character only, second-delimiter | Character to place between time units SS and TTT | . (period) |
The second-delimiter applies only if time-format is 2. You must enclose the delimiters with single quotation marks.
You can suppress either the first-delimiter or second-delimiter character by using a single quoted null string.
Examples
$TIME(argument) | Returns... |
---|---|
$TIME | HH:MM:SS |
$TIME(1) | HH:MM:SS |
$TIME(1,'-') | HH-MM-SS |
$TIME(1,' ') | HH MM SS |
$TIME(1,) | HHMMSS |
$TIME(2) | HH:MM:SS.TTT |
$TIME(2,'-') | HH-MM-SS.TTT |
$TIME(2,,) | HHMMSSTTT |