Tuesday, 26 August 2014

SQLServer

how to add minutes to datetime in sql server?

I have added 3 minutes on today Date & Time.

select GETDATE() Add_Time
select (dateadd(minute,(3),getdate())) After_Added_Time


Result :- 12:55 to 12:58

No comments:

Post a Comment

Thanks for comments.