Parameters Date instead DateTime

[codrutza]

SQL Server Management Studio Express

Maybe you help me with this:

I have the next script:
create PROCEDURE procedA
@FromDepDate smalldatetime,
@ToDepDate smalldatetime
AS

SELECT
…
Table.NNumber

FROM Table
WHERE Table. LIKE 'ao%'
AND Table.Company='A'
…
AND @FromDepDate<=Table.DepDate
AND Table.DepDate<=@ToDepDate

And I base on it a report made with CrystalReports.

When the users execute the report, appears a calendar at each parameter @FromDepDate, @ToDepDate, including the time(minutes, seconds...) and I want to appear just the date.

I want to covert from smalldatetime in smalldate or something like that.

Is it possible?

 

[markros]

In SQL Server 2008 and up there is new DATE type you can use.

PluralSight Learning Library

 

[simian336]

you can also convert it to a string and take the first 10 characters.

Simi