Re: how to add time to NOW() function

[Michael Stassen]

Or simply

  NOW() + INTERVAL 60 SECOND

Michael

[EMAIL PROTECTED] wrote:

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

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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]