HI,
How do you add three minutes to a date in mysql database ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Arjun PanwarPosted Dec 22, 2011, 4:58 AM
Prabhu RajaPosted Dec 21, 2011, 5:50 AM
SELECT ADDDATE(NOW(), INTERVAL 3 MINUTE) as required_date;
@Aarti, Your Query is fine but i think its works for Sql Server Only.
AartiPosted Dec 21, 2011, 5:08 AM
declare @minutes int
set @minutes =3
SELECT DATEADD(mi,@minutes,GETDATE()) as Date;
Jaganathan BantheswaranPosted Dec 19, 2011, 11:35 PM
Try like this,
select DATE_ADD(curdate(), INTERVAL 3 MINUTE);