Unload with data conversion with CASE and INTO
This example uses a CASE statement to unload a character, based on a date field, and shows the INTO clause which can also convert datatypes. Datatypes can also be converted using scalar functions in the select rather than the INTO clause (next example).
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*