Обсуждение: Strftime or Date_format like function?

hi!

I wonder, but is it possible to make 
a format like this: '1999.02' from the date '1999-02-01'

in mysql:select date_format('Y.m', date_field) from table;

so basicly I'm looking for a strftime() like function
thanks,
    redax