I'm looking to return a date format of DD:MM:YY in query analyzer and I keep getting the same format (YYYY:MM:DD)..
Here is my query: select convert(smalldatetime, getdate(), 1)
I also tried all the other style codes (101, 121, 111, 11, 12, etc.. ) Nothing seems to work!
