Difference between revisions of "MDY()"

From Lianjapedia
Jump to: navigation, search
Line 22: Line 22:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Expressions and Type Conversion]]
+
[[Category:Formatting Functions]]
[[Category:Expressions and Type Conversion Functions]]
+
[[Category:Date and Time Data]]
+
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]

Revision as of 08:21, 4 February 2013

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

Lianja Server, Lianja