Date math functions...
| From: | SBCSI) | Date: | Wed, 15 Jan 2003 16:18:48 +0000 |
| Subject: | Date math functions... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24866@lists.php.net to get a copy of this message | ||
I have a question about using DATE_ADD in MySQL. I am not sure if
this is the most effective way of dealing with this problem so I am asking
here. The situation is that I am working on modifying a calendar system for
our use. Our On-Call rotation is such that when someone is On-Call over the
weekend they automatically get Monday off. I have created a page to
simplify inputting the On-Call schedule into the calendar system, and now I
want the Monday off to be automagically scheduled when a weekend On-Call is
entered. The way that I see for doing this is adding 1 day to the end date
of the weekend On-Call and using that as the input for the day off
scheduling. Here is a bit of what I have at this point...
if ($DailyStopYear) {
$result = mysql("$DBName","SELECT (TO_DAYS('$StopDate') -
TO_DAYS('$StartDate'))") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$dateDiff = $row[0];
}
} else {
$dateDiff = 0;
}
if ($dateDiff == 3) {
mysql("$DBName","UPDATE Balances SET CompEarned=CompTaken+8 WHERE
said='$said'") or die(mysql_error());
mysql("$DBName","INSERT INTO Log VALUES('DATE_ADD($StopDate,
INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')") or die(mysql_error());
My big question is about using the "DATE_ADD" MySQL function inside
the INSERT statement. Is this allowed? If it is allowed, is it a bad idea
for some reason? Is there a better way of doing this? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265@sbc.com
Web: http:\\ldsa.sbcld.sbc.com