Date Diff Help

[Anon]

Hello quick Question,

I have a MySQL table with a datetime feild holding when an auction ends, i need to select all the auctions that have finished.

SELECT * FROM end WHERE ...

the feild name is "end" i just need to select the ones that are done so sumthing like

WHERE end is less then NOW() but i am not sure of the syntax.

Thanx in advance!

[vponz]

If in the the field END there is data only when the auction ends, then the query will be:

Select * from auctions where end is not null;

But if you want to retrive the aucions with a date less than now, the query is:

Select * from auctions where ends < now();

(See the section 6.3.4 Date and time functions of the MySql Manual)

Víctor Ponz
Spain