Page is a not externally linkable
- Code, Content, and Presentation
---- Need help Creating A Database that has a time element
skross - 10:09 pm on Feb 14, 2012 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4417558.htm
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')
Brought to you by WebmasterWorld: http://www.webmasterworld.com