Re: how to add time to NOW() function

2004-08-07 Thread 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]

Re: how to add time to NOW() function

2004-08-06 Thread SGreen 
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 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]

RE: how to add time to NOW() function

2004-08-06 Thread Amit_Wadhwa 
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]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]