Simple Date Question

[Irksome]

Hi all,

 

I have a basic SQL database containing a few text fields and a date field. The format for the date field is MM/DD/YYYY.

 

The information is displayed in a simple table on a php page, ordered by date. This all works so far, but what I need is to display the MONTH in one column, and the DAY in the next.

 

But, I also want the MONTH to be displayed as shorthand text, i.e. JAN, FEB etc.

 

So this is how it is now:

 

01/01/2009 |text here

01/01/2009 |text here

 

This is how I want it:

 

JAN |04 |text here

FEB |05 |text here

 

Any help on how this is done would be greatly appreciated.

 

Thanks.

[ram4nd]

You can use PHP function date with timestamp.

[JustLikeIcarus]

You could also take a look at the mysql YEAR(), MONTH(), and DAY() function to extract parts of a date then order by the cols you want.