MySQL Forums
Forum List  »  InnoDB

Re: Problem loading records between 2 dates...
Posted by: Felix Geerinckx
Date: February 09, 2006 02:36AM

[Your question has nothing to do with MySQL Transactions. Please choose a more appropriate forum next time (e.g. newbie)]

Andrew Stokes wrote:

> SELECT id,subject,date,type,category,numreads,keywords
> FROM User1
> WHERE date BETWEEN '2/5/2006 1:48:46 AM' AND Now() AND type >= '1'

Your datetime literals should be in 'yyyy-mm-dd hh:mm:ss' format.
You can use the STR_TO_DATE() function to convert if necessary.
See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem loading records between 2 dates...
1673
February 09, 2006 02:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.