1 Reply Latest reply: Oct 5, 2013 3:33 AM by jariola RSS

    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.