Click here to Skip to main content
15,917,859 members
Home / Discussions / Database
   

Database

 
AnswerRe: Insert Problem Pin
_anil_7-Mar-07 21:02
_anil_7-Mar-07 21:02 
GeneralRe: Insert Problem Pin
Colin Angus Mackay8-Mar-07 0:10
Colin Angus Mackay8-Mar-07 0:10 
Questionproblem on on date filtering Pin
firestoper7-Mar-07 19:45
firestoper7-Mar-07 19:45 
AnswerRe: problem on on date filtering Pin
andyharman7-Mar-07 22:40
professionalandyharman7-Mar-07 22:40 
GeneralRe: problem on on date filtering Pin
firestoper7-Mar-07 22:53
firestoper7-Mar-07 22:53 
GeneralRe: problem on on date filtering Pin
Pete O'Hanlon8-Mar-07 0:45
mvePete O'Hanlon8-Mar-07 0:45 
GeneralRe: problem on on date filtering Pin
andyharman8-Mar-07 1:38
professionalandyharman8-Mar-07 1:38 
AnswerRe: problem on on date filtering Pin
Harini N K7-Mar-07 23:59
Harini N K7-Mar-07 23:59 
Hi
For date filtering, try this:

From front-end, pass default value as Min: 01/01/1900 and Max: 01/01/9999 if date values are not entered or blank

In your select statement, add this statement
IsNull(DateCol,'01/01/1900') >= Convert(nvarchar(12),@FromDate,101) AND 
IsNull(DateCol,'01/01/9999') <= Convert(nvarchar(12),@ToDate,101)


Change date format from '101' to anything based on the format (whether MM/dd/yyyy or dd/MM/yyyy) you are storing in the database.

IsNull function on the left side is required as if you are allowing NULL values for the date field.

That 's it.



Rate this message. Thank you. Harini Smile | :)

QuestionAuto database connection when SQL Server 2005 restarts Pin
zxc897-Mar-07 18:43
zxc897-Mar-07 18:43 
Questioncommunicating SQL server with DB2 Pin
ajit zamindar7-Mar-07 18:34
ajit zamindar7-Mar-07 18:34 
QuestionDatabase contention Pin
Darkness847-Mar-07 11:56
Darkness847-Mar-07 11:56 
AnswerRe: Database contention Pin
Dave Kreskowiak7-Mar-07 12:30
mveDave Kreskowiak7-Mar-07 12:30 
GeneralRe: Database contention Pin
Darkness847-Mar-07 12:38
Darkness847-Mar-07 12:38 
GeneralRe: Database contention Pin
Dave Kreskowiak7-Mar-07 12:46
mveDave Kreskowiak7-Mar-07 12:46 
QuestionHeterogeneous queries Pin
alexrad7-Mar-07 11:03
alexrad7-Mar-07 11:03 
AnswerRe: Heterogeneous queries Pin
alexrad7-Mar-07 11:18
alexrad7-Mar-07 11:18 
QuestionReturning a DataSet from a Stored Procedure within a S.P. Pin
dwatkins@dirq.net7-Mar-07 9:44
dwatkins@dirq.net7-Mar-07 9:44 
AnswerRe: Returning a Resultset from a Stored Procedure within a S.P. Pin
andyharman7-Mar-07 22:36
professionalandyharman7-Mar-07 22:36 
Questionhow split function work in sql [modified] Pin
findtango7-Mar-07 5:06
findtango7-Mar-07 5:06 
AnswerRe: how split function work in sql Pin
Mark J. Miller7-Mar-07 5:29
Mark J. Miller7-Mar-07 5:29 
QuestionHow to insert data from Dataset to Data tables in SQL Pin
Nagaraj.k7-Mar-07 2:35
Nagaraj.k7-Mar-07 2:35 
AnswerRe: How to insert data from Dataset to Data tables in SQL Pin
Marek Grzenkowicz7-Mar-07 4:11
Marek Grzenkowicz7-Mar-07 4:11 
QuestionRe: How to insert data from Dataset to Data tables in SQL Pin
Nagaraj.k7-Mar-07 20:23
Nagaraj.k7-Mar-07 20:23 
AnswerRe: How to insert data from Dataset to Data tables in SQL Pin
Marek Grzenkowicz7-Mar-07 21:26
Marek Grzenkowicz7-Mar-07 21:26 
AnswerRe: How to insert data from Dataset to Data tables in SQL Pin
praveen_gattu20007-Mar-07 21:28
praveen_gattu20007-Mar-07 21:28 

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.