List:General Discussion« Previous MessageNext Message »
From:James Black Date:April 27 2005 6:31pm
Subject:re: getting hours from two datetime columns
View as plain text  
-----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 hope this makes sense.

I am thinking I am going to be doing this in my application.

Thanx for any suggestions.

- --
"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
James Black    james@stripped
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCb9puikQgpVn8xrARAgTBAJ0eefvxMCqjG5UUWa7vlaFYR5LSMQCfSLiF
niYw22pzYxgVTy6bybgJ80Q=
=Ysmy
-----END PGP SIGNATURE-----
Thread
re: getting hours from two datetime columnsJames Black27 Apr
  • Re: getting hours from two datetime columnsPeter Brawley27 Apr