How to use GET_FORMAT on a query?

[William Stokes]

Hello,
I have a following select query:

SELECT event_id,name,date,time,place,type,info FROM test_table
WHERE (group = '$group') AND (type = 'Game' OR type = 'training')
ORDER BY date ASC

The date is stored to DB in format YYYY-MM-DD. I need to output the date at european style like: dd.mm.yyyy. I picked this "GET_FORMAT(date,'EUR')" up from the manual but cant get it to work in the the test environment. Can some help please?

Thanks a lot
-Will