Greenguy's Board - View Single Post

AcidMaX · 2007-07-19, 09:56 AM

Other options are:

SELECT * FROM tablename WHERE date = now();

OR

SELECT * FROM tablename WHERE date BETWEEN '2007-06-01 00:00:00' AND '2007-06-01 23:59:59'

really depends on your database structure. Always multiple ways to skin a cat.

2007-07-19, 09:56 AM	#4
AcidMaX Programming till my fingers bleed. Join Date: Aug 2003 Location: Michigan Posts: 876	Other options are: SELECT * FROM tablename WHERE date = now(); OR SELECT * FROM tablename WHERE date BETWEEN '2007-06-01 00:00:00' AND '2007-06-01 23:59:59' really depends on your database structure. Always multiple ways to skin a cat.