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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
