<div>
<div class="content wysiwyg-content">
help quickly please on sql 2000 query for a datetime field dont know correct syntax for querring datetime<br />
<br />
want to do following<br />
<br />
select *<br />
from tblcall<br />
where datelogged &gt;='2007/05/16 00:00:00' and datelogged &lt;='2007/06/10 00:00:00'<br />
<br />
how do I correctly format this query for datelogged (this is a datetime format)<br />
<br />
<br />
<br />

</div>
</div>


help quickly please on sql 2000 query for a datetime field dont know correct syntax for querring datetime

want to do following

select *
from tblcall
where datelogged >='2007/05/16 00:00:00' and datelogged <='2007/06/10 00:00:00'

how do I correctly format this query for datelogged (this is a datetime format)





datetime formats in query sql 2000

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.