Ancora date e query

[reny2000]

Come mai questa query non mi sortisce nessun risultato?

SELECT * FROM periods WHERE '04-05-2005' BETWEEN 'From' AND 'To'


Id, Name ,From ,To
3 , alta ,2005-01-01,2005-05-01
4 , altissima,2005-05-02,2005-09-30
5 , bassa ,2005-10-01,2005-12-31



Grazie 1000
Reny

[piero.mac]

SELECT * FROM periods
WHERE '2005-05-04' BETWEEN From AND To