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...
[SOLVED] mysql/date
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Code: Select all
... WHERE EXTRACT( DAY FROM `date_field`) = '5'