KT.DATETIME

Declaration

SUBROUTINE KT.DATETIME(output,dates,times)

Description

This subroutine can be used to convert a field that contains dates (in internal format) and a field that contains times (in internal format) into a date/time string that can be converted into a standard SQL date/time field using the USQLDATETIME conversion.

Input Interface

output	Undefined.
dates	A string of internal dates. These may be value delimited or sub-value delimited.
times	A string of internal times. These may be value delimited or sub-value delimited.

Output Interface

output	A string in the format of datetime where date and time are in internal format delimited by an asterisk. If the dates* and times parameters are multi-valued or multi-subvalued, the returned string will follow that structure. For example: `* DATES = 10476]10479]10501 TIMES = 15980]34290]45098 OUTPUT = 1047615980]1047934290]1050145098 `
dates	Unchanged.
times	Unchanged.

Scope of Use

This subroutine interface can be used from a Kourier export.

Example

In this example, field 35 contains a list of dates in internal format while field 36 contains a list of times in internal format. The CALL to KT.DATETIME will merge those two fields together following the structure of the DATES variable. The resulting string will be converted into a SQL date/time string by the USQLDATETIME conversion.