Posted by Codik on 03/08/06 15:30
Good day.
I don't understand why You are using DATETIME field, when You want
finding data only by date. My opion is. You create a DATE field and You
use for 1. query:
SELECT * FROM table WHERE date = '2006-01-01'
And for 2. query:
SELECT * FROM perform1 WHERE date >= '2006-01-01' AND date <=
'2006-01-03'
--
When my English is bad, sorry.
Navigation:
[Reply to this message]
|