Difference between revisions of "MDY()"
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) (→See Also) |
||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a date as a character string | Function to return a date as a character string | ||
− | |||
==Syntax== | ==Syntax== | ||
MDY(<expD>) | MDY(<expD>) | ||
− | |||
==See Also== | ==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()]] | + | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOA()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOT()]], [[DTOV()]], [[ELAPTIME()]], [[EMPTY()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[ISLEAPYEAR()]], [[LEAPYEARS()]], [[LTOS()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[MTOS()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS]], [[STOD()]], [[STOT()]], [[STR()]], [[STRFTIME()]], [[TIME()]], [[TIMEOFDAY()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[TYPE()]], [[VAL()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] |
− | + | ||
==Description== | ==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. | 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== | ==Example== | ||
Line 21: | Line 17: | ||
April 4, 1990 | April 4, 1990 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
Line 27: | Line 22: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
− | + | ||
− | + | ||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] |
Latest revision as of 11:21, 7 October 2019
Purpose
Function to return a date as a character string
Syntax
MDY(<expD>)
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOA(), DTOC(), DTOM(), DTOS(), DTOT(), DTOV(), ELAPTIME(), EMPTY(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), LEAPYEARS(), LTOS(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), STOT(), STR(), STRFTIME(), TIME(), TIMEOFDAY(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), 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