Table of Contents

, , ,

TIMESTAMP

Description

Returns the timestamp constant built from the given numbers

Parameters

An integer constant indicating day (1-31), an integer constant indicating month (1-12), an integer constant indicating year, an integer constant indicating hours (0-23), an integer constant indicating minutes (0-59).

Alternatively a timestamp can be created from 2 parameters – one date and one timestamp. Only time values from the second parameter are used to create a timestamp.

Example

IF TIMESTAMP (DAY_OF_MONTH (Account.OpeningDate), 4, 2004, 11, 0) = 07/04/2004 11:00 THEN ...