Query Datetime problem

[Anon]

I am learning PHP/mySQL by creating a simple diary which allows me to make an entry and record the date and time I make the entry.

I have my tables set up with an entry column(varchar) and a date column(Datetime).

Now I want to query my table to get all entries for the 21 January 2000 for instance but is this possible without also providing the exact time the entry was made?

Can I query a Datetime column with the date alone?

Is the answer to have seperate Date and Time columns?

many thanks.

Kenny

[lawnmowerman]

What I have done for this in the past is to do a query like:

SELECT * FROM Diary WHERE datecolumn LIKE '2001-01-21%

Hope this helps...

-Rich

[arnihr]

No, there's a mySQL function for selecting for example 30 days old inserts...

vincent answered that question for me not so long ago..

the function is called DATE_SUB, but I don't remeber exacly how to use it...

somewhat like this 🙂

SELECT * from tbl_name WHERE $date <= DATE_SUB(date, INTERVAL 30 DAY)

where DATE_SUB(date_col,INTERVAL expr type)

Look it up in the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Good luck, Arni