Hi Chris,
The following query should work for you.
select date_sub(date_col, interval weekday(date_col) day),
date_add(date_col, interval 6-weekday(date_col) day) from table_name
Anvar.
At 07:20 PM 25/11/2001 -0500, you wrote:
>Hey all,
>
>I'm hoping someone can help me out with a little da
Well, whatever language you are using to output your data, there should be
some unix tampstamp converting function.
In php it's date().
On Sunday 25 November 2001 04:20 pm, Chris Cooper wrote:
> Hey all,
>
> I'm hoping someone can help me out with a little date/time problem I'm
> having. I've go
Hey all,
I'm hoping someone can help me out with a little date/time problem I'm
having. I've got a database full of timestamps that I want to group
together based on their week. I can use the WEEK() function or
DATE_FORMAT() to convert the timestamp to a week number, but I'd rather
display the bo