Viewing 4 posts - 1 through 4 (of 4 total)
Thanks a lot Anthony 🙂
August 8, 2012 at 3:26 am
#1523016
Thanks, this is what I wanted 🙂
Just a small query. Is this the most efficient/recommended way to achieve the desired output?
August 8, 2012 at 3:11 am
#1523014
Yes, it is. Here is a snapshot of the data:
1Started 2012-08-07 14:33:35.790
1Running 2012-08-07 15:41:41.000
1Completed 2012-08-07 17:51:51.000
2Started2012-08-07 04:51:51.000
2Running2012-08-07 12:12:31.000
3Started2012-08-07 07:12:31.000
August 8, 2012 at 3:00 am
#1523009
The time column actually contains the time in correct format. I have just given a sample.
August 8, 2012 at 2:51 am
#1523002