Returns a character expression in day-month-year format (for example, 31 May 1998) from a Date or DateTime expression. The month name isn't abbreviated.
DMY(dExpression | tExpression) |
Parameters
- dExpression
- Specifies the Date expression from which DMY(В ) returns a character string in day-month-year format.
- tExpression
- Specifies the DateTime expression from which DMY(В ) returns a character string in day-month-year format.
Return Value
Character
Remarks
If SET CENTURY is OFF, DMY(В ) returns a character string in a dd-Month-yy format (for example, 16 February 98). If SET CENTURY is ON, the format is dd-Month-yyyy (for example, 16 February 1998).
Example
В | Copy Code |
---|---|
CLEAR SET CENTURY OFF ? DMY(DATE( )) SET CENTURY ON ? DMY(DATE( )) |