SOLVED: SQL: how to just return day of month from a query that return the who date

[bobcpg]

this will return

2005-11-25

how can i have it just return the day data. ie;

have it return

25

SOLVED: Select DATE_FORMAT(date, '%e') from event;