Difference between revisions of "DTOM()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert a date to DD-Mmm-YYYY format | Function to convert a date to DD-Mmm-YYYY format | ||
| − | |||
==Syntax== | ==Syntax== | ||
DTOM(<expD>) | DTOM(<expD>) | ||
| − | |||
==See Also== | ==See Also== | ||
[[AMPM()]], [[CDOW()]], [[CTOD()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[STOD()]], [[TIME()]], [[VTOD()]], [[YEAR()]] | [[AMPM()]], [[CDOW()]], [[CTOD()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[STOD()]], [[TIME()]], [[VTOD()]], [[YEAR()]] | ||
| − | |||
==Description== | ==Description== | ||
The DTOM() function is used to convert date expressions to DD-Mmm-YYYY format. If <expD> is not a valid date expression, DTOM() will return an empty string. The DD-Mmm-YYYY format is the calendar date format in Lianja Mirage. | The DTOM() function is used to convert date expressions to DD-Mmm-YYYY format. If <expD> is not a valid date expression, DTOM() will return an empty string. The DD-Mmm-YYYY format is the calendar date format in Lianja Mirage. | ||
| − | |||
==Example== | ==Example== | ||
| Line 20: | Line 16: | ||
10-Oct-2000 | 10-Oct-2000 | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 11:54, 11 December 2012
Purpose
Function to convert a date to DD-Mmm-YYYY format
Syntax
DTOM(<expD>)
See Also
AMPM(), CDOW(), CTOD(), CMONTH(), DATE(), DAY(), DMY(), DOW(), DTOC(), DTOS(), DTOV(), MDY(), MONTH(), MTOD(), SET CENTURY, SET DATE, SET MARK, STOD(), TIME(), VTOD(), YEAR()
Description
The DTOM() function is used to convert date expressions to DD-Mmm-YYYY format. If <expD> is not a valid date expression, DTOM() will return an empty string. The DD-Mmm-YYYY format is the calendar date format in Lianja Mirage.
Example
? dtom({10/10/2000}) 10-Oct-2000
Products
Lianja Server, Lianja
