KT.DATETIME

Kourier Integrator Online Help

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 date*time 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 = 10476*15980]10479*34290]10501*45098
*

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 Export Conversion Codes conversion.