Perfect. Thanks, Anvar.
-- coop On Sun, 2001-11-25 at 22:20, Anvar Hussain K.M. wrote: > 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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
