Search Results

Thank you , I appreciate your time for me, I think this will work out for me, but need to test this against table.

Sample records
---------------
# Name Time
1 Elvis 12
2 Victor 12:00
3 Yorker 12:13:14
4 Prince 5-12:13:14

The columns are separated by white space..but if you look at the 'time'...

The 5th column value "5-12:13:14" should be converted into "5 days 12 hrs 13 minutes and 14 seconds" and stored into table in the database.. This value will be like 13:14 meaning that 13 hours and 14...

Hi guys

I have my 5th column like this

12
12:00
12:13:14
5-12:13:14

Meaning

5 days 12 hrs 13 minutes and 14 seconds

I need to split this column into above meaning format. But...