General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only