Your tables aren't setup very well. You should google for
normalization and 'boyce codd normal form'
-Eric
On Sat, 16 Oct 2004 22:27:51 +0200, owca <[EMAIL PROTECTED]> wrote:
> I'm trying get current week, starting from monday to sunday:
>
> select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19,
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id
from tydzien where to_days(day) between
to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting
day*/ and
(to_days(now())- mod(to_days(now()),7)
or the week because I don't feel the week
>number is very informative.
>
>e.g. Given the timestamp '2004095959' (a Wednesday), I would like to
>output '2001-11-12 to 2001-11-18' (which is Monday to Sunday).
>
>Is there a way using the date/time functi
n't feel the week
> number is very informative.
>
> e.g. Given the timestamp '2004095959' (a Wednesday), I would like to
> output '2001-11-12 to 2001-11-18' (which is Monday to Sunday).
>
> Is there a way using the date/time functions of MySQL to make this
&g
d rather
display the boundary dates for the week because I don't feel the week
number is very informative.
e.g. Given the timestamp '2004095959' (a Wednesday), I would like to
output '2001-11-12 to 2001-11-18' (which is Monday to Sunday).
Is there a way using the date/ti
At 10:31 AM -0800 2/5/01, Daniel Kirk wrote:
>Does MySQL have any date/time functions -> can anyone give me a URL where I
>can find some documentation on it. I'm looking for SQLServer equivalents of
>DateAdd(), DateDiff(), Month(), Year() etc
The MySQL Reference Manual is
Does MySQL have any date/time functions -> can anyone give me a URL where I
can find some documentation on it. I'm looking for SQLServer equivalents of
DateAdd(), DateDiff(), Month(), Year() etc
thx dan
-
Before
