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

skross - 10:09 pm on Feb 14, 2012 (gmt 0)


so if I wanted to select contracts that are active between 5/1/12 up to 9/1/12 would this work?

select * from contracts where contract_start <= DATE('2012-05-01') and contract_finish >= DATE('2012-09-01')

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