DATE_AND_TIME Constants

Overview

DATE constants and TIME constants can also be combined to form so-called DATE_AND_TIME constants.

Syntax

dt#<date and time declaration>

Instead of dt# you can use the following:

  • DT#

  • date_and_time#

  • DATE_AND_TIME#

Enter the date and time declaration in format <year-month-day-hour:minute:second>.

You can enter seconds as real numbers. This allows you to specify fractions of a second.

DATE_AND_TIME values are internally handled as DWORD values, containing the time span in seconds since 01.01.1970, 00:00 clock until February 7, 2106 06:28:15.

Examples 

DATE_AND_TIME#1996-05-06-15:36:30
dt#1972-03-29-00:00:00

For further information, refer to the description of the Date and Time Data Types.