You can do it very nicely with MySQL:
$query = "SELECT WEEKDAY( '{$mydate}' )" ;
Provided your date is correctly formatted ( yyyy-mm-dd )
Ignatius
____________________________________________
----- Original Message -----
From: "Rodrigo Corr�a" <[EMAIL PROTECTED]>
To: "PHP1" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 3:57 PM
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
