Hi,
Can someone help me with the following:
We like to calculate the time (duration) between Start time and End time of a process, we created two tables with the names “sscreate1” DataType=datetime as Start Time and “sscomp1” DataType=datetime as End Time.
I have no idea how the SQL queries must look like to calculate the duration in H, Min, Sec
Thanks,
NM
Can someone help me with the following:
We like to calculate the time (duration) between Start time and End time of a process, we created two tables with the names “sscreate1” DataType=datetime as Start Time and “sscomp1” DataType=datetime as End Time.
I have no idea how the SQL queries must look like to calculate the duration in H, Min, Sec
Thanks,
NM