Hi friends,
I am using IDS 7.31 on HP-D370 Server. In SQL query I would like to find out the time difference between two days. For. E.g Previous day say 19/04/02 22:30:00 to 20/04/02 06:30:00 Hrs. I would like to know the time difference i.e 8 Hrs, 9 Hrs etc.
I tried same thing in 4GL also, since the from time is more than to time I am not getting the proper reuslt.
Will you give me a solution.
G.R.P.
I am using IDS 7.31 on HP-D370 Server. In SQL query I would like to find out the time difference between two days. For. E.g Previous day say 19/04/02 22:30:00 to 20/04/02 06:30:00 Hrs. I would like to know the time difference i.e 8 Hrs, 9 Hrs etc.
I tried same thing in 4GL also, since the from time is more than to time I am not getting the proper reuslt.
Will you give me a solution.
G.R.P.