Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Need help Creating A Database that has a time element


Demaestro - 10:53 pm on Feb 14, 2012 (gmt 0)


What you are describing could mean 2 things.

1) Do you mean you want contracts that were active for at least one day in that range? EG if contact_finish is 5/2/12 would it be returned because it was active for 2 days during that time period, but not all.

Or

2) Do you mean you want contracts that were active during the entire range given? EG if the contract_start is 2012-05-02 and contract_finish is 2012-08-29


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4417558.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com