DATE_AND_TIME Constants

Overview

DATE constants and TIME_OF_DAY 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:

oDT#

odate_and_time

oDATE_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.

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 TIME data types.