5 Replies Latest reply: Oct 14, 2011 12:47 PM by Anand Chouhan RSS

    Query on time function

    Chris Hopkins

      Hi, i am trying to display a time field properly as a dimension, my data for this field is in the following format..

       

      093025

       

      which is the correct format but its missing the colons (09:30:25)

      How do i insert the colons? i have tried but all i am getting is 00:00:00..

       

      Thanks