SELECT LANGUAGE LANG,
        to_char(lm_date, 'Day', 'nls_date_language ='||decode(LANGUAGE,
            'DU','Dutch',
            'EN','English',
            'FR','French'
            )) DAY,
            gui_user_id USERID,
            loginname NICKNAME
FROM gui_users;