DTOT( ) Function

Returns a DateTime value from a Date expression.

DTOT(dDateExpression)

Return Value

DateTime

Parameters

  • dDateExpression
    Specifies the Date expression from which a DateTime value is returned.

Remarks

The format of the DateTime value DTOT( ) returns depends on the current SET DATE and SET MARK settings. If a century isn't supplied, the twentieth century is assumed.

DTOT( ) adds a default time of 12:00:00 AM (if SET HOURS is 12) or 00:00:00 (if SET HOURS is 24) to the date to produce a valid DateTime value.

Example

SET HOURS TO 12
? DTOT({^2004-02-16}) && Displays 02/16/2004 12:00:00 AM

See Also

Reference

CTOT( ) Function

DATE( ) Function

SEC( ) Function

SECONDS( ) Function

SET SECONDS Command

SET HOURS Command

TIME( ) Function

Other Resources

Functions

Language Reference (Visual FoxPro)