Home Forums Reporting Services Reporting Services Adding 0's to time in SSRS Expression RE: Adding 0's to time in SSRS Expression

  • November 20, 2013 at 7:59 am

    #1667820

    In SQL you could just do this:

    CAST('1:2:3' AS DATETIME)[/code]

    which would return "1900-01-01 01:02:03.000" and then use SSRS to extract the time only, preserving the zeros.

    I'm on LinkedIn