Compare a input date with the inserted date time in sql server
|
Smith
2568
Points
74
Posts
|
Hi, I want to compare a input date with the inserted date time in sql server.
Views:
9375
Total Answered: 1 Total Marked As Answer: 1 Posted On: 31-Jul-2015 04:40 Share: 
|
Answers
|
Brian
2232
Points
14
Posts
|
Hi Smith, Suppose you get the date from input field as format MM/dd/yyyy. You can directly compare in sql query with string date format MM/dd/yyyy ie 12/25/2015 as: SELECT <FIELDNAME> FROM <TABLENAME> WHERE CONVERT(DATETIME,CONVERT(VARCHAR,<DATEFIELD>,101))='12/25/2015'
Posted On:
01-Aug-2015 23:05
|
