date format in db and output on screen

[kabbi~thkek]

Hi,

I have a form (step1) which inserts some data (serialnr and type and date as
hidden field) into the database, then users are directed to another page
(step2) where further details for the just inserted data can be inserted (like:
location, user, and the just inserted values (in step 1) are displayed and can
be adjusted.

My question is:
I use a MySQL database so the values for date have to be inserted like this:
0000-00-00 (Y-M-D).
I just give the form field a value like this:
<cfoutput>#DateFormat(Now(), "YYYY-MM-DD")#</cfoutput>

However in step2 the value needs to be displayed from the database. It is
displayed like this:
{ts '2005-10-04 00:00:00'} this is not right, does anyone know how i could get
the values displayed in a normal way?

Hopefully someone can help me.

Thank you in advance,

Kabbi

[Dan Bracuk]

There are two ways. One is to use the Cold Fusion dateformat function after
you select the field. The other, if mySql has such an animal, is to use a
database function that converts dates to text. Oracle to_char is one example.

[jdeline]

Just use the date format function again -
DateFormat(myQuery.databaseDate, "YYYY-MM-DD")