JavaScript Editor js editor     Web development 



Main Page

Returns a Date value from a DateTime expression.

TTOD(tExpression)

Parameters

tExpression


Specifies a date and time expression from which TTOD(В ) returns a Date value. tExpression must evaluate to a valid DateTime. If tExpression contains only a time, Visual FoxPro adds the default date of 12/30/1899 to tExpression and returns this default date.

Return Value

Date

Example

The following example creates a Datetime type variable named gtDtime. TYPE(В ) displays T, indicating the variable is a Datetime type. TTOD(В ) is used to convert the variable to a date type, and TYPE(В ) now displays D, indicating the variable is a date type after the conversion.

В Copy Code
STORE DATETIME( ) TO gtDtime  && Creates a Datetime type memory variable
CLEAR
? "gtDtime is type: "  
?? TYPE('gtDtime')  && Displays T, Datetime type value

gtDtime = TTOD(gtDtime)     &&  Converts gtDtime to a date value
? "gtDtime is now type: "  
?? TYPE('gtDtime')  && Displays D, character type value

See Also



JavaScript Editor js editor     Web development