Yes datatype is DATE only, and nls_date_format is DD/MM/RRRR