how to add 2 dates that are in string format to get the next date

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Sep 2008
Posts: 13
Reputation: agz86 is an unknown quantity at this point 
Solved Threads: 0
agz86 agz86 is offline Offline
Newbie Poster

how to add 2 dates that are in string format to get the next date

 
0
  #1
Sep 17th, 2008
hi all.i have 2 dates in string format.i need to add these 2 dates to get the next date. is there any sql query for this?? Plz sum1 help me. urgent!! Thanx in advance...
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: how to add 2 dates that are in string format to get the next date

 
0
  #2
Sep 17th, 2008
you posted this in the asp forum, but you are asking for sql

how are you wanting to add dates?
you can add dates together, but i don't really know what good that would do for you

be more clear on what you want

if you want to just add days lets say

  1. dateadd(d,1,getdate())
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Join Date: Sep 2008
Posts: 1
Reputation: udaybhoite is an unknown quantity at this point 
Solved Threads: 0
udaybhoite udaybhoite is offline Offline
Newbie Poster

Re: how to add 2 dates that are in string format to get the next date

 
0
  #3
Sep 20th, 2008
hi guys
Originally Posted by dickersonka View Post
First convert both string into date format
then two dates can be add in vb.net using function.
So for in ASp.net forum u need to right customised function.
Same in SQL for Ms SQL SERVER using procedure u can convert strings to a date format
and then using datediff & dateadd function user can add to diff. dates are in string format
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC