with mysql its:
WEEKDAY(date)
Returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 =
Sunday):
mysql> SELECT WEEKDAY('1998-02-03 22:23:00');
-> 1
mysql> SELECT WEEKDAY('1997-11-05');
-> 2
http://www.mysql.com/doc/en/Date_and_time_functions.html
in php its:
string date ( string format [, int timestamp])
and w - day of the week, numeric, i.e. "0" (Sunday) to "6" (Saturday)
http://www.php.net/manual/en/function.date.php
Not sure which you wanted since this is the php-db group :)
Cheers
Jason
-----Original Message-----
From: Rodrigo Corrêa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 8:58 AM
To: PHP1
Subject: [PHP-DB] Help with date....
How can i find out the day of the week in one date??
like => 07/01/2002 the day of the week is " 3 " thurday
like => 18/01/2002 the day of the week is " 6 " saturday
is there a way to do that?
----------------------------------------------------------------------------
----
Equipe Pratic Sistemas
Rodrigo Corrêa
Fone: (14) 441-1700
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
