As far as SQL Server is concerned, '9/11/02' and '9/11/02 00:00:00' will evaluate to the same value.
There's probably something else going on.
-Mike
>I am using Crystal Reports to report on a stored procedure in SQL 2000. For the purposes of my query I just need the date and not the time. Actually, the time portion is what is screwing me up. If I execute the following in the Query Analyzer it works fine:
>
>EXEC NLF_Test '9/11/02'
>
>However, the programs designer has stored the datetime as 9/11/02 00:00:00.
>
>How can I change the input parameter to just the date?
>
>I have delcared it as follows @dPayDate datetime. How do I extract the pertinent data. For some reason I am having trouble with concatenation.
>
>Thanks