date wise search

Question

i write one query select * from userinfo WHERE [LoadDate]>='2016/10/01' and [LoadDate] the result shows of the date 01/10/2016 to 02/10/2016 i cannot see the data of 03/10/2016 why?

Ananth G · Answer

try this select * from userinfo where Convert(Datetime,loaddate,111)>= CONVERT(Datetime, '2016/10/01' , 103) and Convert(Datetime,loaddate,111) '2016/10/03' , 103)

Prakash Kumar · Answer

select * from userinfo where Convert ( varchar ,loaddate,111)>= '2016/10/01' and Convert ( varchar ,loaddate,111) '2016/10/03' select * from userinfo where Convert ( varchar ,loaddate,111) between '2016/10/01' and '2016/10/03' try this one

Nitin Sontakke · Answer

Please try to understand how query is seen by SQL Server. It looks as follows: WHERE [LoadDate]>='2016/10/01 00:00:00' and [LoadDate] If you notice, the load date in later part of query is just the beginning of the 3rd October. The entire day is not covered in this query. Instead if you give explicit query as follows, it works: WHERE [LoadDate]>='2016/10/01 00:00:00' and [LoadDate] Hope it helps!

Midhun Tp · Answer

Hi, It may be because, you are using datetime column and comparing it with date only. Please try below query - select * from userinfo WHERE convert(DATE,[LoadDate]) >='2016/10/01' and convert(DATE,[LoadDate])

Pooja Chowdhury · Answer

i checked it if the query is select * from userinfo where [LoadDate] between '01/10/2016' and '02/10/2016' i get only the data of01/10/2016 if i wnat to get01/10/2016 to 03/10/2016' then the query is select * from userinfo where [LoadDate] between '01/10/2016' and '04/10/2016' but this is not right way

Pooja Chowdhury · Answer

i checked it

Rajeesh Menoth · Answer

Hi, Please check your code properly. Demo : https://www.techonthenet.com/sql/between_try_sql.php https://www.techonthenet.com/sql/between.php

Pooja Chowdhury · Answer

only i get the result of 01/10/2016

Rajeesh Menoth · Answer

Hi, Check my updated answer. or Use Between Operator. select * from userinfowhere [LoadDate] between '01/10/2016' and '02/10/2016' Reference : http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_between

Pooja Chowdhury · Answer

please it from your end using this query i didn't get last date data

Rajeesh Menoth · Answer

Hi, Use between operator or like this : select * from userinfowhere [LoadDate]>= '01/10/2016' and [LoadDate] '02/10/2016' Or select * from userinfowhere [LoadDate] between '01/10/2016' and '02/10/2016' Reference : http://stackoverflow.com/questions/5125076/sql-query-to-select-dates-between-two-dates

date wise search

Answers (11)