You can do it very nicely with MySQL:
$query = SELECT WEEKDAY( '{$mydate}' ) ;
Provided your date is correctly formatted ( -mm-dd )
Ignatius
- Original Message -
From: Rodrigo Corrêa [EMAIL PROTECTED]
To: PHP1 [EMAIL PROTECTED]
Sent:
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 (
Well...
1 day = 60*60*24 = 86400
You figure it out from there :)
Just one example.
Aaron
-Original Message-
From: Dankshit [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2002 12:06 PM
To: PHP; PHP1
Subject: [PHP-DB] Help with date
How can i add days to a date??
If you use MySQL:
SELECT DATE_ADD( $my_date, INTERVAL n DAY ) AS new_date ;
Ignatius
- Original Message -
From: Dankshit [EMAIL PROTECTED]
To: PHP [EMAIL PROTECTED]; PHP1 [EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 6:06 PM
Subject:
Rodrigo,
Is there a way to convert a date 20/11/2002 to a Float number in PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
=Check out UNIX timestamps (but watch the valid date range),
=dn
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Is there a way to convert a date 20/11/2002 to a Float number in
PHP,
since the date starts in 30/12/1899, just like the delphi treats the
dates
Yeah, of course. To convert 20/11/2002 into a float, just do
echo (float)20/11/2002;
and you get 20!!
Or you can use strtotime() to convert
