Home Forums SQL Server 2008 T-SQL (SS2K8) How to split the date format into month with year? RE: How to split the date format into month with year?

  • January 1, 2014 at 8:09 am

    #1676723

    Jeff Moden (12/31/2013)

    Lynn Pettis (12/31/2013)

    Assuming this is still true: billed_date datetime

    right('0' + cast(month(billed_date) as varchar(2)),2) + '-' + cast(year(billed_date) as varchar(4))

    ... or...

    SELECT RIGHT(CONVERT(CHAR(10),GETDATE(),105),7)

    To the OP: And you can learn about COVERT and the different format codes it accepts by reading Books Online as well.

    Remember, Books Online can be your friend.