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?...

dates from mysql

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?

Re: dates from mysql

if you store it in a date field and you call it up with just a set of
<cfoutput> tags it will do that. I just use the function #DateFormat(date,
"yyyy-mm-dd")# to format it as i need. If you saved it in a text or char field
it would come up as you placed it in. Hope that helps.

Re: dates from mysql

ya thanks, I have been using the dateformat function, just trying to get some
incite into how/way ColdFusion interacts with MySQL for example is it a
MySQL/ColdFusion issue or does this happen with all DBMS, does MySQL send the
data to ColdFusion in that format or does ColdFusion know it's a date and
changes it?