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
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