Select a DATE Parameter in CR and use it as a DATETIME data type in SP

[pajr777]

Hi,

I have a stored procedure which requires datetime parameter. When I create a CR on the SP, CR automatically creates parameters matching those in the SP.

However, I want the user to enter DATE parameters and not DATETIME parameters.

EG I want the use to enter @From = 01 Jan 2003 , @To = 31 Jan 2003.

To work this needs to be passed to the SP as '01-Jan-2003 00:00:00' and '31-Jan-2003 23:59:59'.

Any tips?

Thanks,

Paul

 

[synapsevampire]

There are a few limited options.

One is to not use an SP, rather a View, and let the where clause pass the date data.

Another option is to create parmeters of a different type, such as varchar(), and then cast/convert them within the SP.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com