Remove date time field

[Anonymous]

Good Morning friends.

I have a qvd file.

This field is as :

06/11/2013 08:10:28 p.m. -------->  06/11/2013

Remove date time field.

I generate the sentence "FLOOR"

DATE(FLOOR(ProductosDim),'DD-MMM-YY') AS KEY2,

¿that's right?

Date:06/11/2013

Hour:08:10:28 p.m

Please!!

thanks for the support!!