<div>
<div class="content wysiwyg-content">
Dear Expert, <br />
<br />
SQL Query question: <br />
SELECT [InsertTime],[FirstName],[<wbr />LastName]<br />
FROM [Prod].[Data].[IncomingUpd<wbr />ate]<br />
WHERE InsertTime IN (2011-11-12-22:33)<br />
PRINT @@ROWCOUNT<br />
<br />
This will show in the database every row in the column InsertTime that have text: 2011-11-12-22:33<br />
Now the data come in around date 2011 november 20 clock time 22:33, clock time is hard coded in the application, I can't do anything there, It would be nice if it only shows date, that however is not the case, is it possible to query 2011-11-12? I tried to put: WHERE InsertTime IN (2011-11-12) It didnt work tho. <br />
<br />
Regards
</div>
</div>


Dear Expert, 

SQL Query question: 
SELECT [InsertTime],[FirstName],[LastName]
FROM [Prod].[Data].[IncomingUpdate]
WHERE InsertTime IN (2011-11-12-22:33)
PRINT @@ROWCOUNT

This will show in the database every row in the column InsertTime that have text: 2011-11-12-22:33
Now the data come in around date 2011 november 20 clock time 22:33, clock time is hard coded in the application, I can't do anything there, It would be nice if it only shows date, that however is not the case, is it possible to query 2011-11-12? I tried to put: WHERE InsertTime IN (2011-11-12) It didnt work tho. 

Regards

SQL Query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.