Difference between revisions of "TSTRING()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert seconds to a time-string | Function to convert seconds to a time-string | ||
− | |||
==Syntax== | ==Syntax== | ||
TSTRING(<expN>) | TSTRING(<expN>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AMPM()]], [[DAYS()]], [[ELAPTIME()]], [[HOURS()]], [[MINUTES()]], [[SECONDS()]], [[SECS()]], [[TIME()]], [[VALIDTIME()]] | + | [[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()]], [[TIME()]], [[TIMEOFDAY()]], [[TIMESTAMP()]], [[TTOC()]], [[TTOD()]], [[TYPE()]], [[VAL()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] |
− | + | ||
==Description== | ==Description== | ||
The TSTRING() function converts <expN> seconds to a time-string in the format "HH:MM:SS". The DAYS() function can be used to return the duration of any remaining days in the <expN> seconds. | The TSTRING() function converts <expN> seconds to a time-string in the format "HH:MM:SS". The DAYS() function can be used to return the duration of any remaining days in the <expN> seconds. | ||
− | |||
==Example== | ==Example== | ||
Line 20: | Line 16: | ||
10:10:10 | 10:10:10 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
− | + | Lianja, Lianja Server | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
− | + | ||
− | + | ||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Function Extensions]] |
Latest revision as of 08:47, 8 October 2019
Purpose
Function to convert seconds to a time-string
Syntax
TSTRING(<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(), TIME(), TIMEOFDAY(), TIMESTAMP(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The TSTRING() function converts <expN> seconds to a time-string in the format "HH:MM:SS". The DAYS() function can be used to return the duration of any remaining days in the <expN> seconds.
Example
? tstring(36610) 10:10:10
Products
Lianja, Lianja Server