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.

Please use BBCode to format your messages in this forum.

Options: ReplyQuote

Written By
Re: Problem loading records between 2 dates...
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.