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