Difference between revisions of "DTOM()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 30: Line 30:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Functions]]

Revision as of 10:10, 2 June 2009

Class

Expressions and Type Conversion


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 Recital Mirage.


Example

? dtom({10/10/2000})
10-Oct-2000


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer