DTODT( )

Topic group Related topics

"Date to DateTime" converts a date to a DateTime value (DT).

Syntax

DTODT(<expD>)

<expD>

The date to return as a DateTime value.

Description

Use DTODT( ) to convert a date into DateTime value. DateTime values are their own type (DT). DTODT( ) only affects the date component of the DateTime value. The time component is displayed as 12:00:00 AM when SET HOURS is set to 12, and 00:00:00 when SET HOURS is set to 24. Where the current date is 12/25/2001;

d1=date()

d2=DTODT(D1)  //Yields 12/25/2001 12:00:00 AM (SET HOURS=12)

          OR 12/25/2001 00:00:00 (SET HOURS=24)

SET DATE determines the order of the day, month, and year.

SET CENTURY determines whether the year is expressed as two or four digits.

SET MARK assigns the separator character.