query statement

[foysal mamun]

i use "Select * from tableName Where joinDate >= '02/05/2006' And joinDate <= '15/05/2006'". it does not work but why, i use sql server. plz help me.

[Tamimi Code]

what do you mean by its not work ?? Tamimi - Code

[foysal mamun]

i mean, it does not return any row but the table contains those type of row which satisfied this condition( joinDate >= '02/05/2006' And joinDate <= '15/06/2006')

[Tamimi Code]

try to excute your query in the query analyzer and see what happen. if its work take a look to your code. Tamimi - Code

[Laubi]

sql won't recognise 02/05/2006! this is just a string and not a date.. Maybe this works 1900-01-04 00:00:00.000 but the safest way is to use an explicit cast like this CAST('1900-01-04 08:00' AS datetime)

[Tamimi Code]

sometimes the sql server configure the date as mm/dd/yy so 15/05/2006 is not a valid date Tamimi - Code

[Hesham Amin]

You better use the yyyyMMdd format with SQL server for dates: This :

foysal mamun wrote:

Select * from tableName Where joinDate >= '02/05/2006' And joinDate <= '15/05/2006'

should be written like: Select * from tableName Where joinDate >= '20060502' And joinDate <= '20060515'

[Stephan Samuel]

Does the exact query entered into SQL Server through Query Analyzer return any rows?