I have gone through the suggested date formats here but didn't find any that meets my requirement.
I have the following date format:
05-JUN-99. 05 being dd as in day, JUN and the year 1999.
I have been asked to convert that to mmddyy (two digit month, two digit day and two digit year).
Any ideas how to do this?
Thanks for your assistance
You can use
select convert(varchar(20),cast('05-JUN-99' as date),10) --Output: 06-05-99 select replace(convert(varchar(20),cast('05-JUN-99' as date),10),'-','') --Output: 060599