Re: DATE - longtext

2003-06-12 Thread Paul DuBois
At 14:44 -0500 6/12/03, Wong Zach-CHZ013 wrote: Hi I have a database whose table has a column, which has a datatype longtext. I then try a query mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND '10/21/2 003'; I thought it would fail since the datatype isnt DATE nor TIMEST

DATE - longtext

2003-06-12 Thread Wong Zach-CHZ013
Hi I have a database whose table has a column, which has a datatype longtext. I then try a query mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND '10/21/2 003'; I thought it would fail since the datatype isnt DATE nor TIMESTAMP. But from the result, it seems to work. 1