date type in MySQL

[wfears]

i store date in a mysql database, the data type is DATE in mysql which store
the date in the format yyyy-mm-dd if I run a query with ColdFusion it will
return that data as a time stamp. I don't understand why, for example {ts
1942-10-01 00:00:00'} why is ColdFusion change the data, this same data is
stored as 1942-10-01 in MySQL. Does ColdFusion some how know the data type
MySQL is using to store the data?

[BKBK]

I can see your point. Alas, we have to live with that. Same thing as the English
writing 0.05 and the French 0,05. MySQL, MS SQL, Oracle,
Coldfusion, etc. each has its own preferred default way of storing dates and
times. That is why there are so many formatting functions for dates and times.