Page 1 of 1

[SOLVED] mysql/date

Posted: Fri Jan 28, 2005 9:50 am
by MrKnight
hello,
in my sql i would like to select all the entries that added on 5th of any month, can be? if so, how?
(dates were stored such as '0000-00-00')
if this is not possiple, i am open to ideas...

Posted: Fri Jan 28, 2005 9:54 am
by feyd

Code: Select all

... WHERE EXTRACT( DAY FROM `date_field`) = '5'
something like that....

Posted: Fri Jan 28, 2005 10:57 am
by MrKnight
thank you so much, it worked... :)
erm thanks once more :D