Difference between revisions of "DTOV()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| − | Function to convert | + | Function to convert Lianja dates to OpenVMS VAXdates |
| − | + | ||
==Syntax== | ==Syntax== | ||
DTOV(<expD>) | DTOV(<expD>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DATE()]], [[DAY()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOS()]], [[MDY()]], [[MONTH()]], [[SET | + | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOA()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOT()]], [[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 DTOV () function converts | + | The DTOV () function converts Lianja dates to VAXdates. A VAXdate data type is a character string with a length of 23. The first 11 characters are the date in the format "DD-MMM-YYYY". The remaining characters are the optional time string of HH:MM:SS.00, which can be turned off with the SET VAXTIME command. Date arithmetic cannot be performed on VAXdates. |
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | |
!Parameters||Description | !Parameters||Description | ||
|- | |- | ||
| Line 21: | Line 17: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | |||
==Example== | ==Example== | ||
| Line 30: | Line 24: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[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:40, 8 October 2019
Contents
Purpose
Function to convert Lianja dates to OpenVMS VAXdates
Syntax
DTOV(<expD>)
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOA(), DTOC(), DTOM(), DTOS(), DTOT(), 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 DTOV () function converts Lianja dates to VAXdates. A VAXdate data type is a character string with a length of 23. The first 11 characters are the date in the format "DD-MMM-YYYY". The remaining characters are the optional time string of HH:MM:SS.00, which can be turned off with the SET VAXTIME command. Date arithmetic cannot be performed on VAXdates.
| Parameters | Description |
|---|---|
| <expD> | The valid date to be converted to a VAXdate |
Example
? dtov({02/02/2000}+7) 9-FEB-2000 00:00:00.00
