Andrew,
Not trying to be a smart-ass, but give this link a try from the Mysql
website. Most likely covers your situation.
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
Don
-Original Message-
From: Andrew Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 3:18 P
Everyone,
I think I've got this licked on my own. Here's what I wound up with. Seems
to work ok.
select nodename, startdate, enddate
from history
where startdate >= concat(date_format(date_sub(now(), interval 1 day),
'%y-%m-%d'), ' 07:00:00')
and startdate <= concat(date_format(now(),'%Y-%m
Hi,
Yes, one column is dedicated to date/time for each record. Data type on that
column is MySQL's datetime type.
Don
-Original Message-
From: Gordon Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Sql SELECT statement to get
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