Date problem

sandeep1234

New Member

Join Date: Jan 2008

Posts: 7
#1

Date problem

Jan 3 '08, 06:56 AM

How to add 3 month 4day and 5 minute on a specific date
If any one know the query then please tell me
Thank you
sandeep kumar pradhan
Bangalore
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Jan 3 '08, 08:05 AM

Originally posted by sandeep1234

How to add 3 month 4day and 5 minute on a specific date
If any one know the query then please tell me
Thank you
sandeep kumar pradhan
Bangalore

adding 3 months, 4days, 5 mins to system date

Code:

select dateadd(mi,5,dateadd(day,4, dateadd(month, 3, getdate())))
Comment

Comment