asked
how to get only mmyyyy format
i need to get date like '092010' .... to get the above format ..i am doing .... month(getdate())+year(getdate()) ...but i am getting '92010'...instead of '092010'...
here's one way.... convert the date to a varchar using style 103 (dd/mm/yyyy), then replace the '/' with '', and take the rightmost 6 chars select right(replace(convert(varchar, getdate(), 103),'/',''),6) which gives (whilst the date is in Sept 2010) 092010 There are literally hundreds of different ways of doing this by using the date conversion styles
