Difference between revisions of "CTOD()"
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) (→See Also) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert character to date | Function to convert character to date | ||
| − | |||
==Syntax== | ==Syntax== | ||
CTOD(<expC>) | CTOD(<expC>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[CDOW()]], [[CMONTH()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[ | + | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[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()]], [[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 CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date. | The CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date. | ||
| − | |||
==Example== | ==Example== | ||
| Line 23: | Line 19: | ||
D | D | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
| Line 29: | Line 24: | ||
[[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 08:35, 8 October 2019
Purpose
Function to convert character to date
Syntax
CTOD(<expC>)
See Also
AMPM(), CDOW(), CMONTH(), 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(), 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 CTOD() function is the character to date conversion function. It converts the character expression specified to a date variable. The character expression must be correctly formatted based on the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN and SET CENTURY ON, require a date in the format "MM/DD/YYYY". If <expC> is an invalid date format the CTOD() function will return an empty date.
Example
mdate = ctod("11/10/2003") ? mdate 11/10/2003 ? type("mdate") D
Products
Lianja Server, Lianja
