SYNAX OF FROM DATE AND TODATE IN SQL2005

Question

HOW TO GET DATA FROM TWO DIFFERENT DATES IN SQL 2005 BY USENG SELECT QUERY.DATATYPE IS DATETIME

Ravi Shekhar · Answer

Hi  Try this select * from table where CreatedDate between convert(varchar'2011-02-25'101) and convert(varchar'2011-02-30'101) go throuh with below link for datetime format conversion http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx http://www.w3schools.com/sql/func_convert.asp Regards Ravi accept as answer if it helped.

Pankaj Pandey · Answer

try this select * from yourtable where date1 between '2013-03-05' and '2014-03-05'

Iftikar Hussain · Answer

Hi Please provide more details. Regards Iftikar

Sanjeeb Lenka · Answer

plz provide more detail so we can able to solve your problem

Jignesh Trivedi · Answer

hi you can try following query with correct table name and date.. select * from table1 where CreatedDate between '2011-02-25' and '2012-02-07' hope this will help you.