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