-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
thanks for your reply but let me be more specific in my question. the week()
function returns a particular week based on 53 weeks in a year. but I want to
be able to return data that exists within a particular week based on a time
period that I specify. That is start counting the number of weeks that are
from a certain timeperiod onwards to another timeperiod.
On Friday 28 March 2003 23:46, you wrote:
> On 28-Mar-2003 Jasmine wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Hi
> > just a question.. wondering if anyone knows how to query for Weekly data
> > (e.g.
> > Week 1 , Week 3... and so forth) from a table that includes the
> > "timestamp"
> > column in a format of ("yyyy-mm-dd hh:mm:ss") .
>
> WEEK()
>
> Regards,
- --
Jasmine Chua
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+hJvzNgvTa7Hj2AURAg1DAKCRXAMnX7ANqX32jru8d/LO37dgrgCfUmIL
D+JtSStI6vfRq/9+Qe/Ir9U=
=dUCz
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
