re: getting hours from two datetime columns

2005-04-27 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there a way to get all of the hours between two datetime columns? For example, if there is an entry that starts at 2005-4-1 3:00:00 and the end is 2005-4-1 11:00:00 I would like to know that this enry was used in hours 3 - 11, or for 8 hours. I

Re: getting hours from two datetime columns

2005-04-27 Thread Peter Brawley
James, Is there a way to get all of the hours between two datetime columns? For example, if there is an entry that starts at 2005-4-1 3:00:00 and the end is 2005-4-1 11:00:00 I would like to know that this enry was used in hours 3 - 11, or for 8 hours. TIMEDIFF( '2005-4-1 11:00:00', '2005-4-1