Hi,
My clients can put their articles on my website. They pay for the real
utilisation of the site. If a client has used 2 slots for all year, then he
pays for them.
Now my articles table has a starddate (when the client has started to sell
his product) and an enddate (when the article is
Bedford Bob schrieb:
Hi,
My clients can put their articles on my website. They pay for the real
utilisation of the site. If a client has used 2 slots for all year, then he
pays for them.
Now my articles table has a starddate (when the client has started to sell
his product) and an enddate
Bob
I'd like to retrieve the total amount of time the articles have been
in the
site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
year).
In a valid-time app like yours, it is usually more sound to mark
current with a
far-in-the-future date than with NULL. Arguably,
Bedford Bob wrote:
I'd like to retrieve the total amount of time the articles have been in the
site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
year).
if an article has been online from 2004-10-01 to null (meaning the article
hasn't been sold yet) then I may count 365