"Michael Fesser" <netizen@gmx.de> wrote in message
news:j52gt3tlsg7tv1b3ml0uhi7p0tlh843g9i@4ax.com...
> .oO(Kram Techie)
>
>>it is DATETIME but for display i have to re-format it.
>
> Ah, OK. But then you can let the database return the day of week, which
> would be more efficient than doing it in PHP. See DATE_FORMAT() for
> details.
>
> http://dev.mysql.com/doc/refman/5.0/...on_date-format
>
> Micha

Hi

i used %a to get short day "SELECT DATE_FORMAT('$datetime', '%a')"
works a treat and the other % values will come in handy at a later date.

Mark