select '2011-02-29' BETWEEN '2011-02-01' AND '2011-03-03'?
this is returning 1. I think between doesn't consider leap year. I want your view on this?
[EDIT]
SELECT DATE( '2010-04-31' )
is returning NULL;
But select str_to_date('2010-04-31', '%Y-%m-%d')
is retuning date.
Why?
Thanks
Venu
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…