gdanalakshmi
Registered User.
- Local time
- Today, 22:45
- Joined
- Nov 26, 2002
- Messages
- 102
I call a function from a query to calculate the time difference between 2 events in a way I want to implement in our process.
If the startdate and enddate fall on the same day, then I want to calculate the difference in terms of hours.
The startdate is like this 11/21/2002 8:04:25 AM and enddate is like this 11/21/2002 4:21:29 PM
How do i extract the date without time so that I can compare the dates?
If the startdate and enddate fall on the same day, then I want to calculate the difference in terms of hours.
The startdate is like this 11/21/2002 8:04:25 AM and enddate is like this 11/21/2002 4:21:29 PM
How do i extract the date without time so that I can compare the dates?
