COMBINED-DATETIME

The COMBINED-DATETIME function combines a date in integer date form and a time in standard numeric time form into a single numeric item from which both date and time components can be derived.

The function type is numeric.

Format

argument-1: Must be in integer date form. For details, see Integer date form.; A value in integer date form is a positive integer that represents a number of days succeeding 31 December 1600, in the Gregorian calendar. It is based on a starting date of Monday, 1 January 1601 and integer date 1 represents Monday, 1 January 1601.; The INTDATE compiler option affects the starting date for the integer date functions. For details, see INTDATE.
argument-2: Must be in standard numeric time form. For details, see Standard numeric time form.; A value in standard numeric time form is a numeric value representing seconds past midnight.

The returned value is determined by arithmetic expression argument-1 + (argument-2/100000). The date occupies the integer part of the returned value and the time is represented in the fractional part of the returned value.

Example

Given the integer date form value "143951", which represents the date 15 February 1995, and the standard numeric time form value "18867.812479168304", which represents the time "05:14:27.812479168304", the returned value would be exactly "143951.1886781247" with the ARITH(COMPAT) compiler option in effect and exactly "143951.18867812479168304" with the ARITH(EXTEND) compiler option in effect.