Difference between revisions of "TIME()"
Yvonne.milne (Talk | contribs) (→See Also) |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the current system time | Function to return the current system time | ||
− | |||
==Syntax== | ==Syntax== | ||
TIME([<expN>]) | TIME([<expN>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AMPM()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[ELAPTIME()]], [[HOUR()]], [[HOURS()]], [[MINUTE()]], [[MINUTES()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET | + | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOA()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOT()]], [[DTOV()]], [[ELAPTIME()]], [[EMPTY()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[ISLEAPYEAR()]], [[LEAPYEARS()]], [[LTOS()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[MTOS()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS]], [[STOD()]], [[STOT()]], [[STR()]], [[STRFTIME()]], [[TIMEOFDAY()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[TYPE()]], [[VAL()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] |
− | + | ||
==Description== | ==Description== | ||
− | The TIME() function returns the current system time as a character string in the format HH:MM:SS. The TIME() function always returns the time in 24 hour format, and is not affected by the SET HOURS TO [12/24] command. The optional numeric expression <expN> must result in a non-zero value | + | The TIME() function returns the current system time as a character string in the format HH:MM:SS. The TIME() function always returns the time in 24 hour format, and is not affected by the SET HOURS TO [12/24] command. The optional numeric expression <expN> must result in a non-zero value. The TIME() function will always return hundredths of seconds as 00. |
− | + | ||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] |
Latest revision as of 08:45, 8 October 2019
Contents
Purpose
Function to return the current system time
Syntax
TIME([<expN>])
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOA(), DTOC(), DTOM(), DTOS(), DTOT(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), LEAPYEARS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), STOT(), STR(), STRFTIME(), TIMEOFDAY(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The TIME() function returns the current system time as a character string in the format HH:MM:SS. The TIME() function always returns the time in 24 hour format, and is not affected by the SET HOURS TO [12/24] command. The optional numeric expression <expN> must result in a non-zero value. The TIME() function will always return hundredths of seconds as 00.
Example
? time() 17:47:24 ? time(1) 17:47:31.00