Date and time conversions

The following table details the conversions for date and time between the application server and the .NET Open Client.

Table 1. .NET Open Client DATE, DATETIME, and DATETIME-TZ conversions
ABL data type Process 
DATE
 Input: Extract Date portion

Output: Time is set to midnight

 
DATETIME
 Input and Output: Date and Time preserved 
DATETIME-TZ
 Input: Use time zone of the .NET Client

Output: Convert to .NET Client time zone