August 16, 2018 at 5:55 am
Hello, I am doing some datetime manipulations in an ssis derived column and as part of this, I need to convert 12 hr to 24hr time. The times are marked AM or PM so no issue identifying them however the cast part of the expression to convert the string_hour back to int so I can add 12 to it for PM times is not working.
Can anyone see what I need to do please?[String_AM_PM] == "AM" ? [String_Hour] + ":" + [String_Minute] + ":" + [String_second] : (DT_UI4) [String_Hour] + ":" + [String_Minute] + ":" + [String_second]
Cheers
Dave
August 16, 2018 at 6:33 am
david_h_edmonds - Thursday, August 16, 2018 5:55 AMHello, I am doing some datetime manipulations in an ssis derived column and as part of this, I need to convert 12 hr to 24hr time. The times are marked AM or PM so no issue identifying them however the cast part of the expression to convert the string_hour back to int so I can add 12 to it for PM times is not working.
Can anyone see what I need to do please?[String_AM_PM] == "AM" ? [String_Hour] + ":" + [String_Minute] + ":" + [String_second] : (DT_UI4) [String_Hour] + ":" + [String_Minute] + ":" + [String_second]Cheers
Dave
Something like this should work for the 'adding 12 hours' part:
(DT_STR, 2, 1252) ((DT_I4) [String_Hour] +12) + ":" + [String_Minute] + ":" + [String_Second]
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
August 16, 2018 at 7:17 am
Phil Parkin - Thursday, August 16, 2018 6:33 AMdavid_h_edmonds - Thursday, August 16, 2018 5:55 AMHello, I am doing some datetime manipulations in an ssis derived column and as part of this, I need to convert 12 hr to 24hr time. The times are marked AM or PM so no issue identifying them however the cast part of the expression to convert the string_hour back to int so I can add 12 to it for PM times is not working.
Can anyone see what I need to do please?[String_AM_PM] == "AM" ? [String_Hour] + ":" + [String_Minute] + ":" + [String_second] : (DT_UI4) [String_Hour] + ":" + [String_Minute] + ":" + [String_second]Cheers
Dave
Something like this should work for the 'adding 12 hours' part:
(DT_STR, 2, 1252) ((DT_I4) [String_Hour] +12) + ":" + [String_Minute] + ":" + [String_Second]
Perfect as always.
Thanks so much.
Final package ended up as 5 levels of derived columns each relying on the previous level.
Had to remember to treat midnight as 0 and midday as 12 still to make it work though.
Dave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply