Hi All,

 

Is there a simpler way of doing a select for a given date, for instance if I
have a datetime field called date

 

And so its populated with a load of values such as 

 

2005-01-07 09:00

2005-01-07 10:00

2005-01-07 11:00

2005-01-07 12:00

 

If I wanted all records which fall on 2005-01-07 I could of course do 

 

Select * from <TABLE> where date > ‘2005-01-07’ and date <
DATE_ADD(‘2005-01-07’, INTERVAL 24 HOUR)

 

However is there a simpler way of doing it by just passing one date like

 

Select * from <TABLE> where date = ‘2005-01-07’

 

?

 


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18/03/2005



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18/03/2005
 

Reply via email to