I have a READER column that is a String 24Hr time in a format of HHMM (Hour Minutes) eg. 1415 = 2:15PM
I need to get this into a TIME data type in SQL Server table.
There is no date part as that is being sent in a separate READER column and stored in a separate table column
I have tried various things but the closest I get generates an error. I am assuming I need to put a formatter in the transformer but Date Format and Reformat Date do not have a simple time reformatter that I can
Can't apply format YYYY-MM-DD HH:NN:SS.FFF for field Time(TIME) value 4:35:00 P
Perhaps another way to go is to load the string into a varchar field in SQL. Then create a stored procedure to the update a time field based of that varchar.
Thanks Dean. Both solutions would be possible (I think) but seems to bring some complexity into the foreground that I was hoping to avoid. I am wondering as I have not experimented yet if t is possible to create a full date time string but use a zero date (eg. "0000-00-00 HH:MM:00.000") filling in HH:MM from the time string. I suspect SQL Server will baulk at an invalid date before realising it only needs the time component.
That could be an interesting way to go too. To your point, you could get a few hours in experimenting. If you go with letting SQL do the work, you'll be able to find resources online.
