Try the function DATE_FORMAT in this syntax DATE_FORMAT(col,"%U");
I don't know if %U is exactly what you want but DATE_FORMAT can format any date column into nearly any format you wish to display. -----Original Message----- From: Jasmine [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: weekly data query -----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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]