Member Avatar for agz86

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...

  • 3 Contributors
  • 2 Replies
  • 105 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by udaybhoite
Member Avatar for dickersonka

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

dateadd(d,1,getdate())
Member Avatar for udaybhoite

hi guys

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.