RE: Finding an ID between two dates

2003-03-14 Thread Roger Davis
D] Subject: Finding an ID between two dates Hey folks! I am stumpedbeen reading the online manual, google groups, to no avail. I have a very simple table: time_period_id int(11) NOT NULL auto_increment, time_period_start date NOT NULL default '-00-00', time_period_end date NOT NULL

Re: Finding an ID between two dates

2003-03-14 Thread Stefan Hinz
Cory, > time_period_id int(11) NOT NULL auto_increment, > time_period_start date NOT NULL default '-00-00', > time_period_end date NOT NULL default '-00-00', > PRIMARY KEY (time_period_id) > I am trying to get the ID that relates to a date falling between the > range of time_period_start

Re: Finding an ID between two dates

2003-03-14 Thread Ignatius Reilly
Quotes missing around dates. WHERE "2003-03-14" ... Ignatius - Original Message - From: "Cory Hicks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 9:05 PM Subject: Finding an ID betwee

Finding an ID between two dates

2003-03-14 Thread Cory Hicks
Hey folks! I am stumpedbeen reading the online manual, google groups, to no avail. I have a very simple table: time_period_id int(11) NOT NULL auto_increment, time_period_start date NOT NULL default '-00-00', time_period_end date NOT NULL default '-00-00', PRIMARY KEY (time_period_i