I need from and To dates query in sql server 2005,

Question

Hi To All, Am new to .net pls help to me, I need From-TO dates query in Sql Server 2005, i have two textboxs, based on that textbox date values i need to display events to the user.

Naresh Avari · Answer

Hi, If you have two textboxes called as txtStartDate and txtEndDate. DateTime startDate = Convert.ToDateTime(txtStartDate.Text); DateTime endDate = Convert.ToDateTime(txtEndDate.Text); SqlConnection con = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand("SELECT * from tblEvents WHERE eventDate BETWEEN '" + startDate + "' AND '" + endDate + "'", con); Hope this helps you...

Prabhakar Reddy · Answer

Thank You, Thank You so much..

Hemant Kumar · Answer

you are welcome :-) Mark as "Accepted Answer" if it helps you .

Hemant Kumar · Answer

Hi Prabhakar, Try this Query select * from tbl_abc where trunc(StartTime) between to_date('2009-07-15', 'YYYY-MM-DD') and to_date('2009-07-16', 'YYYY-MM-DD'); Do refer this link for Getting the data based on the To and From Dates in SQL SERVER http://www.aspdotnet-suresh.com/2012/08/query-to-get-data-between-two-dates-in.html

I need from and To dates query in sql server 2005,

Answers (4)