How can we help you today? How can we help you today?

Autocomplete stored procedure parameter date values shown as datetime

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
naumad
0

Comments

2 comments

Sort by
  • 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
    0
  • 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
    FredericoJ
    0

Add comment

Please sign in to leave a comment.