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