Difference between revisions of "MDY()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 31: Line 31:
 
[[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]]

Revision as of 10:28, 2 June 2009

Class

Date and Time Data


Purpose

Function to return a date as a character string


Syntax

MDY(<expD>)


See Also

AMPM(), CDOW(), CMONTH(), CTOD(), DAY(), DMY(), DOW(), DTOC(), DTOS(), DTOV(), EPOCH(), MONTH(), SET CENTURY, SET DATE, SET EPOCH, STOD(), TIME(), VTOD(), WEEK(), YEAR()


Description

The MDY() function returns a character string of the form of "Month name Day, Year" from the specified <expD>. If CENTURY is OFF, then a 2-digit year is returned.


Example

set century on
? mdy({04/04/1990})
April 4, 1990


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer