Difference between revisions of "MTOD()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert a date string in the format DD-Mmm-YYYY to a date data type | Function to convert a date string in the format DD-Mmm-YYYY to a date data type | ||
− | |||
==Syntax== | ==Syntax== | ||
MTOD(<expC>) | MTOD(<expC>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AMPM()]], [[CDOW()]], [[CTOD()]], [[ | + | [[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()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[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 MTOD() function is used to convert date strings in the format DD-Mmm-YYYY to date data types. The returned date will be in the format determined by SET CENTURY, SET DATE and SET MARK. | + | The MTOD() function is used to convert date strings in the format DD-Mmm-YYYY to date data types. The returned date will be in the format determined by SET CENTURY, SET DATE and SET MARK. If <expC> is not a valid date string, MTOD() will return an empty date. |
− | + | ||
− | + | ||
==Example== | ==Example== | ||
Line 23: | Line 18: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Date and Time Data Functions]] |
Latest revision as of 11:23, 7 October 2019
Contents
Purpose
Function to convert a date string in the format DD-Mmm-YYYY to a date data type
Syntax
MTOD(<expC>)
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(), MDY(), MINUTE(), MINUTES(), MONTH(), 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 MTOD() function is used to convert date strings in the format DD-Mmm-YYYY to date data types. The returned date will be in the format determined by SET CENTURY, SET DATE and SET MARK. If <expC> is not a valid date string, MTOD() will return an empty date.
Example
set century on ? mtod("10-Oct-2008") 10/10/2008