SELECT g.gui_user_id, g.loginname, g. LANGUAGE, to_char(g.last_connection_date, 'Day/Mon/YYYY','NLS_date_LANGUAGE='||CASE UPPER(g.LANGUAGE)
WHEN 'DU' THEN 'DUTCH'
WHEN 'FR' THEN 'FRENCH'
ELSE 'ENGLISH'
END) "Date"
FROM gui_users g;