Autocomplete stored procedure parameter date values shown as datetime

naumad

When autocomplete fills out the parameters for a stored procedure with a date parameter, a datetime value is incorrectly entered instead of a date value:

EXEC rpt.usp_get_list
@vXCode = '' -- varchar(50)
, @dStartDate_Local = '2017-07-10 18:48:45' -- date

FredericoJ

Hi @naumad,

Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6446) to track it.

Best regards,

Frederico

FredericoJ

Hi @naumad,

We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).

You can find more information about this release in this forum post.

Kind regards,

Frederico