The DateToDateTime function is a built-in function that converts Date d to a datetime value, adding the time component (#00:00:00#).

Input parameters

d: Date Type

Output parameters

DateTime Type

Examples

Usage

Result

DateToDateTime( #2001-09-14# )

#2001-09-14 00:00:00#

Remarks

You should check the limits of the Date data type.

See Also

Available Conversion Functions to Date Time | Available Built-in Functions