I see similar questions, but most have to do with datetime or fairly different requirements.
I have a CSV report that has a time column stored as HH:MM[:SS] (if over 1 day, it adds :00 for seconds... annoyingly, and I don't have control over how the report itself runs.) I think, in the derived column task, we can drop seconds.
- 23:54 = 23H 54M
- 27:35:00 = 27H 35M 00S
My questions are:
- If the CSV loads the column as text, what expression do I need for the derived column?
- What should I set the data type as in the SQL database?
Pertinent info: SQL Server 2014 and SSDT for VS 2013
Thank you, Wes