Returns a character-string date in a yyyymmdd format from a specified Date or DateTime expression.
DTOS(dExpression | tExpression) |
Parameters
- dExpression
- Specifies the Date expression DTOS(В ) converts to an eight-digit character string.
- tExpression
- Specifies the DateTime expression DTOS(В ) converts to an eight-digit character string.
Return Value
Character
Remarks
This function is useful for indexing tables on a Date or DateTime field. It is equivalent to DTOC(В ) when its optional 1 argument is included.
The character string returned by DTOS(В ) isn't affected by SET DATE or SET CENTURY.
Example
В | Copy Code |
---|---|
CLEAR ? DTOS(DATE( )) |