Add Minutes to a date

Question

HI How do you add three minutes to a date in mysql database ?

Arjun Panwar · Answer

Thanks to All

Prabhu Raja · Answer

Hi Try this one. SELECT ADDDATE(NOW() INTERVAL 3 MINUTE) as required_date; @Aarti Your Query is fine but i think its works for Sql Server Only.

Aarti · Answer

Hi Arjun declare @minutes int set @minutes =3 SELECT DATEADD ( mi  @minutes  GETDATE ()) as Date ;

Jaganathan Bantheswaran · Answer

Hi Try like this select DATE_ADD ( curdate ()  INTERVAL 3 MINUTE ) ;