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(Datetimeloaddate111)>= CONVERT(Datetime '2016/10/01'  103) and Convert(Datetimeloaddate111) '2016/10/03'  103)

Prakash Kumar · Answer

select * from userinfo where Convert ( varchar loaddate111)>= '2016/10/01' and Convert ( varchar loaddate111) '2016/10/03' select * from userinfo where Convert ( varchar loaddate111) 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 T P · 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])

aiswarjya sarengi · 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

aiswarjya sarengi · 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

aiswarjya sarengi · 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

aiswarjya sarengi · 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