[SOLVED] Date Query

[bigrossco]

I have a database that has dates on it for jobs and want a page to dispaly anything that is in the database / form which is equal to that days date i.e. if a record on the database has 08-01-2007 it should only show stuff from that date (today) and nothing else

 

r

[trq]

SELECT datefld FROM tbl WHERE datefld = '08-01-2007';

[bigrossco]

sorry should of said i want it to use the current date automaticly i.e. system date

[obsidian]

sorry should of said i want it to use the current date automaticly i.e. system date

 

The best thing to do is to change your data type to a SQL recognized DATE or DATETIME field. This way, you can immediately do matches against the current date and/or time with the built in functions such as DATE() or NOW(). In the interim, though, you could probably just do this:

SELECT * FROM tbl WHERE dtfld = DATE_FORMAT(NOW(), "%m-%d-%Y");

[bigrossco]

jsut so you know my date field is as a date type on the database

[obsidian]

jsut so you know my date field is as a date type on the database

 

Good... your description of the 08-01-2007 format threw me off. Typically, a SQL DATE field is YYYY-MM-DD format.