TIMESTAMP

Returns the timestamp constant built from the given numbers

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.

IF TIMESTAMP (DAY_OF_MONTH (Account.OpeningDate), 4, 2004, 11, 0) = 07/04/2004 11:00 THEN ... 
  • Last modified: 2023/05/09 01:20