Date Question

[N-Bomb(Nerd)]

Actually, I lied.. I have two questions. 

 

I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, how would I go about formatting the output? For example it would display "2009-11-30 02:48:40".. how can I change that formatting around?

 

Also, I wanted to do a sort to display items within my table monthly.. is there anything I can use to only pull/sort data by the month?

[trq]

date.

BETWEEN.

[Cardale]

When selecting the date from the database with your query you need to format it through MYSQL.

 

Example

SELECT date_FORMAT(thedate, '%M %e, %Y, %l:%i%p') as newdate FROM your_table;