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