retrieve the day of the week

..oO(Kram Techie)

>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.

Glad it worked out.

Micha

Kram Techie schrieb:
> Hi
>
> i am trying to find a way to retrieve the day of the w from a mysql dat
e.
> example 11 Mar 2008 22:32:06
> should equate to Tue, or Tuesday
>
> Googled but no Joy. many online examples but i need a hint or some source 
to
> work with.
>
> Mark
>
>

you can do that with php ...

$time = strtotime(mysql date);
echo date('D', $time);

for sure a solution in mysql is more efficient

mfg
k42b3

"Christoph Kappestein" <meecrob@k42b3.com> wrote in message
news:frgfnn$6hb$02$1@news.t-online.com...
> Kram Techie schrieb: 
>
> you can do that with php ...
>
> $time = strtotime(mysql date);
> echo date('D', $time);
>
> for sure a solution in mysql is more efficient
>
> mfg
> k42b3

$time = strtotime("24 Feb 2008 22:51:08");
echo date('D', $time);
Sun

as MySQL works a dream I'll stick with that.

Mark