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?

  • December 31, 2013 at 6:15 pm

    #1676692

    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))