Difference between revisions of "MDY()"

Revision as of 23:33, 7 December 2012

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