Hello.
You have given to few information to give a specific answer. Please
include the output of "DESC your_table" in your mail next time.
Most people probably solve that by determining the date in the
application part and just inserting it in the SQL query. The following
is an SQL-only solution (not necessarily "pretty").
Presuming you have some timestamp column (called "ts" afterwards)
containing the time.
SELECT whatever
FROM your_table
WHERE ts BETWEEN DATE_FORMAT( NOW(), "%Y%m%d070000" ) AND
DATE_FORMAT( NOW() - INTERVAL 1 DAY, "%Y%m%d07000000" )
(this needs a recent 3.23 version, but you get the idea)
Bye,
Philemon.
On Thu, Apr 25, 2002 at 08:22:48AM -0500, [EMAIL PROTECTED] wrote:
> Hi Everyone,
>
> I am very new to database programming, and am working on an application
> where I need to select all records between yesterday at 7:00am and today at
> 7:00am. Obviously this can be run at any time or day. This has to be a very
> common sql SELECT statement, but for the life of me I can't find anything.
> I'm either not doing the right google search or looking in the right places.
>
> I apologize if this is the wrong place to post this message. Any direction
> either towards the SELECT statement answer or where to look would be much
> appreciated. Thanks in advance.
>
> Don Whitlow
> Quad/Graphics, Inc.
> Manager - Enterprise Computing
> [EMAIL PROTECTED]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
