Hi,
Can you please help me convert the datetime field to day, minute, hour, minute and seconds.
I want to get the difference of these fileds (these are datetime fields)
{prob.close.time} - {prob.open.time}
I want to display the difference in month, day, hour, minutes, seconds
i.e. 11/18/09 03:54:00 - 11/19/09 05:00:00 =
1 01:06:00sample data:
7/25/2009 7:19:58 PM |
8/4/2009 2:40:44 PM |
8/12/2009 9:25:16 AM |
7/8/2009 3:16:19 PM |