user2362008 user2362008 - 1 year ago 99
SQL Question

How to get my required date format?

how to get this format (jun-2016) from saledate (20160624)

only shown the first 3 character of month name, my saledate is nvarchar datatype in tblSale
Thanks in advance

Answer Source

Simple Try this one

    DECLARE @SaleDate NVARCHAR(20) = '20160624'

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download