Post reply

Computed Column error

  • July 23, 2005 at 11:33 pm

    #576618

    I think this could work :

    Convert(varchar(20), ReportDate, 112))

    The 112 is the iso format which is deterministic. That conversion isn't deterministic because the date format of the connexion makes the formating change and needs to be calculated on the fly. See BOLs for more details.

Viewing post 1 (of 2 total)

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