Home Forums SQL Server 2008 T-SQL (SS2K8) How to get month number like Jan -01, Feb-02 ... Instead of Jan-1, Feb-2 RE: How to get month number like Jan -01, Feb-02 ... Instead of Jan-1, Feb-2

  • March 19, 2013 at 4:37 pm

    #1598666

    try this and see if it helps:

    select right('0' + cast(month(getdate()) as varchar),2)