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 3
-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 h