Click here to Skip to main content
15,569,745 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Solution To Solve By ArunVijay Pin
ArunVijay15-Apr-08 21:02
ArunVijay15-Apr-08 21:02 
GeneralRe: Runtime Error after publishing aspx page!!! Pin
ArunVijay15-Apr-08 21:06
ArunVijay15-Apr-08 21:06 
GeneralRe: Runtime Error after publishing aspx page!!! Pin
Phivos Stylianides16-Apr-08 13:56
Phivos Stylianides16-Apr-08 13:56 
GeneralRe: Runtime Error after publishing aspx page!!! Pin
Phivos Stylianides16-Apr-08 13:56
Phivos Stylianides16-Apr-08 13:56 
GeneralMaster Page weirdness Pin
#realJSOP15-Apr-08 9:46
mva#realJSOP15-Apr-08 9:46 
GeneralRe: Master Page weirdness Pin
Herman<T>.Instance16-Apr-08 1:30
Herman<T>.Instance16-Apr-08 1:30 
QuestionGet records between Today and 2 years from input date Pin
munklefish15-Apr-08 8:49
munklefish15-Apr-08 8:49 
GeneralRe: Get records between Today and 2 years from input date [modified] Pin
Blue_Boy15-Apr-08 12:28
Blue_Boy15-Apr-08 12:28 
In T-SQL this is one of the possibilities:

declare @date as varchar(15) <br />
set @date = '2008-04-15' //here u give input parameter<br />
select  * from myTable  where Datetime >= convert(varchar(15),cast(@date as datetime),102)<br />
and datetime<=  convert(varchar(15),(cast(@date as datetime)-365*2),102)


instead format date 102 use ur according format

Hope it helps...


I Love T-SQL

modified on Tuesday, April 15, 2008 7:20 PM

QuestionRe: Get records between Today and 2 years from input date Pin
munklefish16-Apr-08 0:45
munklefish16-Apr-08 0:45 
GeneralRe: Get records between Today and 2 years from input date Pin
Blue_Boy16-Apr-08 1:22
Blue_Boy16-Apr-08 1:22 
GeneralRe: Get records between Today and 2 years from input date Pin
munklefish16-Apr-08 2:06
munklefish16-Apr-08 2:06 
GeneralRe: Get records between Today and 2 years from input date Pin
Blue_Boy16-Apr-08 5:13
Blue_Boy16-Apr-08 5:13 
GeneralRe: Get records between Today and 2 years from input date Pin
munklefish16-Apr-08 5:52
munklefish16-Apr-08 5:52 
GeneralRe: Get records between Today and 2 years from input date Pin
Blue_Boy16-Apr-08 6:04
Blue_Boy16-Apr-08 6:04 
GeneralTransactionScope and EntLib Pin
Rohde15-Apr-08 8:42
Rohde15-Apr-08 8:42 
GeneralRe: TransactionScope and EntLib Pin
Rohde15-Apr-08 10:14
Rohde15-Apr-08 10:14 
GeneralDynamic Link disabling in a GridView Pin
Ekjon15-Apr-08 7:49
Ekjon15-Apr-08 7:49 
GeneralRe: Dynamic Link disabling in a GridView Pin
Ekjon15-Apr-08 13:00
Ekjon15-Apr-08 13:00 
GeneralRe: Dynamic Link disabling in a GridView Pin
Herman<T>.Instance16-Apr-08 1:35
Herman<T>.Instance16-Apr-08 1:35 
GeneralConfused GridView Count Question Pin
ffowler15-Apr-08 6:18
ffowler15-Apr-08 6:18 
GeneralRe: Confused GridView Count Question Pin
Ekjon15-Apr-08 12:02
Ekjon15-Apr-08 12:02 
GeneralRe: Confused GridView Count Question Pin
Herman<T>.Instance16-Apr-08 1:32
Herman<T>.Instance16-Apr-08 1:32 
GeneralRe: Confused GridView Count Question Pin
ffowler16-Apr-08 3:08
ffowler16-Apr-08 3:08 
GeneralRe: Confused GridView Count Question Pin
Herman<T>.Instance16-Apr-08 3:15
Herman<T>.Instance16-Apr-08 3:15 
GeneralRe: Confused GridView Count Question Pin
ffowler16-Apr-08 4:23
ffowler16-Apr-08 4:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.