I have two fields in the same SQL 2K server. The fields are identified as arrival_time and departure_time. The fields are date/time fields and contain information as such:
10/20/2004 08:00:00 AM 10/24/2004 04:00:00 PM
How can I calulate the difference in this information to display the difference in hours?