:58 AM
To: [EMAIL PROTECTED]
Subject: how to add time to NOW() function
i want to add time to NOW() function, that means something like this,
$addTime = 60;
NOW() + $addTime;
where 60 are seconds. I am not sure whether to add seconds or is there
any other format I can use to add time to NOW
Use
DATE_ADD(NOW(),INTERVAL 1 HOUR)
Or
DATE_ADD(NOW(),INTERVAL 60 MINUTE)
Or
DATE_ADD(NOW(),INTERVAL 3600 SECOND)
-Original Message-
From: Deepak Dhake [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 07, 2004 1:58 AM
To: [EMAIL PROTECTED]
Subject: how to add time to NOW() function
Your options depend heavily on what version of MySQL you are running.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Deepak Dhake <[EMAIL PROTECTED]> wrote on 08/06/2004 04:28:20
PM:
> i want to add time to NO
i want to add time to NOW() function, that means something like this,
$addTime = 60;
NOW() + $addTime;
where 60 are seconds. I am not sure whether to add seconds or is there
any other format I can use to add time to NOW() function? please let me
know.
thanks in advance.
deepak
--
MySQL General M