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