Look at the date functions at: http://www.mysql.com/doc/D/a/Date_and_time_functions.html and search for the date_format table Within it you will see the following:
%U Week (00..53), where Sunday is the first day of the week %u Week (00..53), where Monday is the first day of the week %V Week (01..53), where Sunday is the first day of the week. Used with '%X' %v Week (01..53), where Monday is the first day of the week. Used with '%x' Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com -----Original Message----- From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:25 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] fiscal week?? On Wed, 31 Jul 2002 21:19:00 +0800 Jason Wong <[EMAIL PROTECTED]> wrote: > On Wednesday 31 July 2002 20:56, Dib, Walid (MED, Stagiaire GEMS) wrote: > > How can i print the fiscal week number on a web page?? > > 1) Work out an algorithm to calculate the fiscal week > 2) Implement algorithm in php or simply use the pear::Date package :) Do not be so rude with newcomers :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
