Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 add two date in sql

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2010-11-01 : 01:51:23
how to add two date in select query in sql

like
select date1 + date2 from tbl

ricky_1605
Starting Member

30 Posts

Posted - 2010-11-01 : 02:17:40
Assuming date1 and date2 are columns of a table and of same datatype.

select date1 + date2 from <table> where <condition>

Nipun Chawla
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-11-01 : 02:55:38
What is the significance to add two dates ?


Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-11-01 : 04:47:57
What is your expected result of adding '20100101' and '20090101'?
Are you trying to accomplish something else, like getting an average of two dates?



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -