I can not get this to work.

I am trying to truncate the date from the database and just display in output the date and not the time.

I am outputting it as a variable in cold Fusion as #Date#

in the query it doesn't recognize the function. Am i putting this in the wrong place in relation to the variable? What is the proper syntex when using a variable?