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