At 16:43 -0700 7/6/04, Scott Haneda wrote:
I can not seem to select a range of timestamp(14) data, something like
Select * from foo where added is in the range of 01/01/2004 to 01/25/2004

Well, one problem might be that 01/01/2004 and 01/25/2004 are not dates... You should specify your values in year-month-day order.


http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html


-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to