3 Replies Latest reply: Sep 30, 2014 12:38 PM by neetha P RSS

    remove date time field

    Carlos Dominguez Canseco

      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!!