Post reply

Datetime DataType as Parameter

  • November 21, 2019 at 5:17 pm

    #3699715

    Hi

    I have datetime parameter. In select query i want to compare it will only datePart

    Thanks

  • November 21, 2019 at 5:28 pm

    #3699718

    Maybe cast to date will help:

    select cast(getdate() as date)

  • November 21, 2019 at 8:16 pm

    #3699794

    If you are only interested in the DATE part, why did you define it as a DATETIME parameter instead of a DATE parameter?

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply