Post reply

max length for local variable

  • June 6, 2005 at 9:02 am

    #563252

    It can be handy with cast/convert when you are not sure of the length of the result.

    select convert(varchar, getdate(),110)

    ------------------------------

    06-06-2005

    (interesting anniversary)

  • June 6, 2005 at 9:26 am

    #563263

    Yup but it's gonna be even better next year.

Viewing 2 posts - 16 through 16 (of 16 total)

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