datetime data

Has any one had experience to retrieve datetime type data into sqlda and then to convert it into char string using dttoasc()? I tried but dttoasc() failed to provide correct data. I wonder whether datetime type data has to be FETCHed INTO a host variable of type dtime_t but cannot be loaded into sqlda since there is no way to initialize dt_qual field if sqlda is used? Thanks in advanced for any information.