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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:13:11
|
| Mahathi writes "Hi I have an application which requires to take the start time and end time from different dates. Can anyone provide me help regarding this. My requirement is "How to take the start date someday in August or from any other month eventhough the present day is in July".I got the idea of the end date. I am just confused with the start date. I will be thankful to any help provided. It is urgent.RegardsMahathi." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-09 : 09:56:05
|
| Do you want to get start date of next month?If so, trySelect DateAdd(Month,DateDiff(Month,0,Getdate())+1,0)MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Start Time from another date