get date:hours :mins from datetime

  • I have something like this:

    2012-04-23 10:54:29.070

    i need to get only something like this:

    2012-04-23 10:54 In SSRS expressions.

    Can anyone tell me how to do this in expressions??

    Thanks in Advance

  • You can do this in the dataset query

    SELECT CONVERT(VARCHAR(16),GetDate(),20)

    where you substitute your date column for GetDate()

    Or you could put this in the Format property of the textbox

    yyyy-MM-dd h:mm

  • Thank you

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

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