asked on
How to compare dates in C# /sql server.
I have date at back end in 3/1/2012 12:00:00 AM
And from front end the date of entry is: 1-March-2012
string s = "select * from mstbt where feeddate>='" + Convert.ToDateTime(txtfdat
And from front end the date of entry is: 1-March-2012
string s = "select * from mstbt where feeddate>='" + Convert.ToDateTime(txtfdat
C#Microsoft SQL Server 2005
Last Comment
Gustav Brock
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
http://victoriayudin.com/2
To play safe, you should convert to date, then format this to the correct string format for SQL Server:
string sqlfdate = "\'" + DateTime.Parse(txtfdate.Text.Trim()).ToString("yyyy-MM-dd") + "\'";
string sqltdate = "\'" + DateTime.Parse(txttdate.Text.Trim()).ToString("yyyy-MM-dd") + "\'";
s = "select * from mstbt where feeddate between " + sqlfdate + " and " + sqltdate + " order by 1 desc,2 desc,3 asc";
ASKER
Thnx
??
There was no ElapsedTimeColumn field but a start and an end date.
/gustav
There was no ElapsedTimeColumn field but a start and an end date.
/gustav