Home Forums SQL Server 7,2000 General display date in format mm/yy or mm/yyyy RE: display date in format mm/yy or mm/yyyy

  • December 8, 2003 at 3:08 pm

    #485192

    Can't you use your report writer for this?

    

    SELECT RIGHT(CONVERT(char(10),GETDATE(),103),7)

    --Jonathan



    --Jonathan