datetime computation

[rtdvoip]

I have just started learning sql and although I have books
a good example is not available for my current question.
Please help....

I have a duration of type int in seconds
I have a start_time of type datetime

how do i compute the end_time of type datetime
using the start_time and duration?

any suggestions?

thanks,
rtdvoip

 

[jhall156]

Check out DateDiff in Books On-Line
DateDiff(ss, <startdatetime>, <enddatetime>)

JHall

 

[dmhirsch]

First step is, look up DATEADD in Books Online, to get the whole syntax. But, basically DATEADD is what you need. If, for example, you wanted to add 2 hours to start_time, you would say:

end_time = DATEADD(hh, 2, start_time)

 

[dmhirsch]

And for seconds,

end_time = DATEADD(ss, duration, start_time)

 

[jhall156]

Once again I assumed something wrong, sorry, thought you wanted to calculate the duration.

JHall