tracy_p
asked on
Time Difference
Hi
i need to display the duration of the time from two columns.each column consists of date and time.
so in third column i need to display time difference between two columns.
i am using Asp,db2
Thank you
i need to display the duration of the time from two columns.each column consists of date and time.
so in third column i need to display time difference between two columns.
i am using Asp,db2
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since you say that the columns contain both data and time, I'll assume they're using the datatype TIMESTAMP.
In that case, use the TIMESTAMPDIFF function.
Here's the defininition / documentation of that function.
HTH,
DaveSlash
Open in new window