Hi, in my table there are two fields, one date and one time field.
I like to add these both values to a single field datetime.

SQL
   SELECT (fldDate + fldTime) AS fldDateTime
endSQL

doesn't work (Type mismatch in expression) 

So I tried 
SQL
   SELECT (CAST(fldDate AS TIMESTAMP) 
           + CAST(fldTime AS TIMESTAMP)) AS fldDateTime
endSQL

Same error

So how do I do it? 

Thanks