When the Query module extracts the response data and places it in the output grid or the saved output files, it manipulates the data as follows:
Text and Multimedia questions stay as strings.
Integer questions become integer/long fields. Integer responses longer than 10 digits are changed to decimal format.
Real and Laboratory questions become reals/singles
Category questions with numeric responses become integer/long fields.
Category questions with alphanumeric responses stay as strings.
Standard dates d/m/y, d/m/y/h/m, d/m/y/h/m/s, m/d/y, m/d/y/h/m, m/d/y/h/m/s, y/m/d, y/m/d/h/m, y/m/d/h/m/s, h/m, h/m/s become date fields.
Non-standard dates (including any date/time question that is set to allow partial dates) y/m, y/m/h/m, y/m/h/m/s, m/y, m/y/h/m, m/y/h/m/s, y/d/m, y/d/m/h/m, y/d/m/h/m/s stay as strings.
The above rules may vary slightly between the different saved output formats.