Value Formats for CSV Output

When Intelligent Advisor Java Batch Processor outputs to comma-separated values (CSV) files, it writes the output in the following manner:

Input values (those provided in the input CSV) are written as they were provided (that is, input format is unchanged).
Output values are written in a format depending on their value type. The formats are outlined in the following table.

Table 1. Value format for CSV outputs
Intelligent Advisor value type	Output format
number/currency	Numeric values are written as decimal numbers with a period as the decimal separator. The number is formatted up to 15 significant decimal places, for example, 3.123456789876543 Uncertain or Unknown values are both written as blank.
text	String values are written as is. Uncertain or Unknown values are both written as blank.
Boolean	Boolean are always written as "true" or "false". Uncertain or Unknown values are both written as blank.
date	Date values are always written in the format "yyyy-MM-dd" where: yyyy is the four-digit year MM is the two-digit month, including leading zero for values below 10 dd is the two-digit day, including leading zero for values below 10 Uncertain or Unknown values are both written as blank.
datetime	Datetime values are always written in the format "yyyy-MM-dd HH:mm:ss" where: yyyy is the four-digit year MM is the two-digit month, including leading zero for values below 10 dd is the two-digit day, including leading zero for values below 10 HH is the two-digit 24-hour hour value, including leading zero for values below 10 mm is the two-digit minute value, including leading zero for values below 10 ss is the two-digit seconds value, including leading zero for values below 10 Uncertain or Unknown values are both written as blank.
time of day	Time of days values are always written in the format "HH:mm:ss" where: HH is the two-digit 24-hour hour value mm is the two-digit minute value ss is the two-digit seconds value Uncertain or Unknown values are both written as blank.