Difference between revisions of "DTOM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to convert a date to DD-Mmm-YYYY format
 
Function to convert a date to DD-Mmm-YYYY format
Line 12: Line 8:
  
 
==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()]]
  
  
Line 27: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Expressions and Type Conversion]]
 +
[[Category:Expressions and Type Conversion Functions]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Functions]]

Latest revision as of 16:59, 27 November 2009

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 Server, Recital