Why does my SQL query return the date in two different formats? After spooling the results to a text file and importing it into Lotus 1-2-3, the date column is in both the date format and character format. Is this a Lotus problem or is it from thequery side?