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 |
|
Akshaya Pargunan
Starting Member
10 Posts |
 Posted - 2011-10-12 : 07:28:04
|
hi
how to get start date of november and end date of october from getdate()
it should be like 01-11-2011 to 31-10-2012
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-10-12 : 07:44:57
|
[code]
select dateadd(month, datediff(month, 0, getdate()) + 1, 0),
dateadd(month, datediff(month, 0, getdate()) + 13, -1)
[/code]
KH
[spoiler]Time is always against us[/spoiler]
|
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-12 : 07:47:51
|
select dateadd(mm,10,dateadd(yy,datediff(yy,0,getdate()),0))
select dateadd(mm,10,dateadd(yy,datediff(yy,0,getdate()),0))-1
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
|
|
|
Akshaya Pargunan
Starting Member
10 Posts |
Posted - 2011-10-12 : 07:48:32
|
| Thank u very much |
|
|
|
|
|
|
SQL 2000 -GET start date and end date in a year c