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] >