Difference between revisions of "MTOD()"

Latest revision as of 11:23, 7 October 2019

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