5 Replies Latest reply: Mar 13, 2013 5:36 PM by Celambarasan Adhimulam RSS

    Help: how to separate date and time

      Hello Qlivers,

           if I want to serarate date and time from a colume contained both date and time together. how do i do it??

      thank you~~

      This is a sample of the date colume.



      none of the codes were actually not working,

      but i actually figured out how to do it, Anyways guys, for future reference, here is what i have::

      Date(date#(date(Floor(departure), 'DD/MM/YYYY'), 'MM/DD/YYYY'), 'MM/DD/YYYY') as OutputDate,

      Timestamp(arrive-Floor(departure), 'hh:mm') as OutputTime;