Difference between revisions of "DTOS()"
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to perform date to string conversion | Function to perform date to string conversion | ||
| Line 32: | Line 30: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 16:58, 27 November 2009
Purpose
Function to perform date to string conversion
Syntax
DTOS(<expD> | <expT>)
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), STR(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The DTOS() function converts the date expression <expD> or date part of the datetime expression <expT> to a character string in the format "YYYYMMDD". This function is particularly useful when creating indexes with mixed data types. The SET DATE, SET MARK and SET CENTURY settings have no effect on this function.
Example
? dtos({02/29/2004}) 20040229 ? dtos({02/29/2004 11:18:54 PM}) 20040229 store dtos({02/29/2004})to m_date ? m_date 20040229 ? type("m_date") C
Products
Recital Server, Recital
