1 Reply Latest reply on Oct 5, 2013 8:33 AM by jariola

    Import csv time only data into a table

    Rarebazza

      Hi, I was wondering if you guys could help me with a problem. I have an excel spreadsheet which has a column of time only data I.e. hh24:mm. Example 15:45.

       

      I have created a table in apex to export this data but the table does not have a data type that's compatible. Is there a way of creating the DDL of the table maybe truncating the timestamp but i don't know the syntax to create this as I'm not sure what to do,  thanks.