This discussion is archived
1 Reply Latest reply: Oct 5, 2013 1:33 AM by jariola RSS

Import csv time only data into a table

Rarebazza Newbie
Currently Being Moderated

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. 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points