RE: Date time format

Alexey Yastremskiy wrote:
> 
> Hello
> 
> As far as I know the default date-time format is ISO, but after the
> installation we decided to switch it. Documentation says we have to
> alter database parameter DATE_TIME_FORMAT, in our case we need EUR
> format. So, we've done it and DBMGUI shows DATE_TIME_FORMAT=EUR, but
> select date from dual still returns ISO formatted date.
> 
> What should we do to alter this situation?

We have to assume that you are using JDBC/ODBC resp. SQLStudio (implicit usage of ODBC).
Because of the ODBC-definition, all of these use ISO-format and do not take care
for the DATE_TIME_FORMAT given during installation (or switched afterwards).

If you need other formats for output, use function CHAR (internal mode) resp.
TO_CHAR (Oracle mode)

Elke
SAP Labs Berlin