Difference between revisions of "DTOV()"

From Lianjapedia
Jump to: navigation, search
Line 26: Line 26:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Expressions and Type Conversion]]
+
[[Category:Formatting Functions]]
[[Category:Expressions and Type Conversion Functions]]
+
[[Category:Date and Time Data]]
+
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]

Revision as of 08:04, 4 February 2013

Purpose

Function to convert Lianja dates to OpenVMS VAXdates

Syntax

DTOV(<expD>)

See Also

CDOW(), CMONTH(), CTOD(), DATE(), DAY(), DMY(), DOW(), DTOC(), DTOS(), MDY(), MONTH(), STOD(), TIME(), 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